FAQ

Search Discussions

66 discussions - 479 posts

  • On this point, Reiser4 fs already implements a number of things which would be desirable for PostgreSQL. For example: write()s to reiser4 filesystems are atomic, so there is no risk of torn pages ...
    Gregory MaxwellGregory Maxwell
    Oct 1, 2005 at 1:44 am
    Oct 8, 2005 at 10:51 pm
  • Greetings, We are running some performance tests in which we are attempting to insert about 100,000,000 rows in a database at a sustained rate. About 50M rows in, our performance drops dramatically. ...
    Kelly BurkhartKelly Burkhart
    Oct 31, 2005 at 5:12 pm
    Nov 14, 2005 at 3:57 pm
  • Hi all, After a long time of reading the general list it's time to subscribe to this one... We have adapted our application (originally written for oracle) to postgres, and switched part of our ...
    Csaba NagyCsaba Nagy
    Oct 12, 2005 at 2:45 pm
    Oct 18, 2005 at 4:48 pm
  • Which effects have UPDATEs on REFERENCEd TABLEs when only columns in the referenced table are updated which are not part of the FOREIGN KEY constraint? I have one "master"-table like create table ...
    Martin LesserMartin Lesser
    Oct 29, 2005 at 11:10 am
    Mar 7, 2008 at 7:21 pm
  • Hello there, This is my first post in the list. I have a deep low-level background on computer programming, but I am totally newbie to sql databases. I am using postgres because of its commercial ...
    Rodrigo MaderaRodrigo Madera
    Oct 18, 2005 at 6:07 pm
    Nov 7, 2005 at 5:58 am
  • I have a SUSE 9 box that is running Postgres 8.0.1 compiled from source. Over time, I see the memory usage of the box go way way up (it's got 8GBs in it and by the end of the day, it'll be all used ...
    Jon BrisbinJon Brisbin
    Oct 10, 2005 at 9:29 pm
    Oct 11, 2005 at 6:11 pm
  • Hello, I am trying to select form table with bytea field. And queries runs very slow. My table: CREATE TABLE files (file bytea, nr serial NOT NULL) WITH OIDS; Query: select * from files where nr 1450 ...
    NSONSO
    Oct 15, 2005 at 1:20 pm
    Oct 18, 2005 at 1:58 am
  • Hi, I'm using PostgreSQL 8.1 beta 3 (packages from Debian experimental), and I have a (rather complex) query that seems to take forever -- when the database was just installed, it took about 1200ms ...
    Steinar H. GundersonSteinar H. Gunderson
    Oct 19, 2005 at 5:45 pm
    Oct 27, 2005 at 12:57 am
  • --On Freitag, Oktober 21, 2005 03:40:47 +0000 "Christian Paul B. Cosinas" wrote: I suppose you looked at the top row of the free output? Because there the disk-cache is counted as "used"... Have a ...
    Jens-Wolfhard SchickeJens-Wolfhard Schicke
    Oct 21, 2005 at 7:23 am
    Oct 25, 2005 at 4:14 am
  • Hi All, I am Kishore doing freelance development of J2EE applications. We switched to use Postgresql recently because of the advantages it has over other commercial databases. All went well untill ...
    Kishore BKishore B
    Oct 22, 2005 at 9:12 pm
    Oct 23, 2005 at 9:35 pm
  • I am running Postgre 7.4 on FreeBSD. The main table have 2 million record (we would like to do at least 10 mil or more). It is mainly a FIFO structure with maybe 200,000 new records coming in each ...
    AuroraAurora
    Oct 26, 2005 at 8:41 pm
    Oct 27, 2005 at 2:34 pm
  • I thought this might be interesting, not the least due to the extremely low price ($150 + the price of regular DIMMs): http://www.tomshardware.com/storage/20050907/index.html Anybody know a good ...
    Steinar H. GundersonSteinar H. Gunderson
    Oct 3, 2005 at 11:02 am
    Oct 5, 2005 at 6:35 pm
  • Hello all First of all, I do understand why pgsql with it's MVCC design has to examine tuples to evaluate "count(*)" and "count(*) where (...)" queries in environment with heavy concurrent updates. ...
    Cestmir HyblCestmir Hybl
    Oct 7, 2005 at 9:24 am
    Oct 8, 2005 at 1:48 pm
  • I was reading a comment in another posting and it started me thinking about this. Let's say I startup an Oracle server. All my queries are a little bit (sometimes a lot bit) slow until it gets its ...
    Martin NickelMartin Nickel
    Oct 21, 2005 at 12:24 pm
    Oct 27, 2005 at 10:48 pm
  • All, I can see why the query below is slow. The lead table is 34 million rows, and a sequential scan always takes 3+ minutes. Mailing_id is the PK for mailing and is constrained as a foreign key ...
    Martin NickelMartin Nickel
    Oct 12, 2005 at 8:31 pm
    Oct 22, 2005 at 1:24 pm
  • Hi to all, I have the following problem: I have a client to which we send every night a "dump" with a the database in which there are only their data's. It is a stupid solution but I choose this ...
    AndyAndy
    Oct 11, 2005 at 11:37 am
    Oct 11, 2005 at 9:48 pm
  • We're running 8.1beta3 on one server and are having ridiculous performance issues. This is a 2 cpu Opteron box and both processors are staying at 98 or 99% utilization processing not-that-complex ...
    PostgreSQLPostgreSQL
    Oct 31, 2005 at 11:16 pm
    Nov 2, 2005 at 2:41 pm
  • The following update was captured in the database log and the elapsed time was 1058.956 ms. A later explain analyze shows total run time of 730 ms. Although isn't the actual time to update the row ...
    DenisDenis
    Oct 27, 2005 at 3:41 pm
    Oct 28, 2005 at 1:34 pm
  • Hi there. I am currently building a system, where it would be nice to use multiple levels of views upon each other (it is a staticstics system, where traceability is important). Is there any ...
    Svenne KrapSvenne Krap
    Oct 26, 2005 at 3:25 pm
    Oct 27, 2005 at 3:45 pm
  • Hi to all, I have the following configuration: Dual Xeon 2.8 Ghz, 1G RAM and postgre 8.0.3 installed. Modified configuration parameters: max_connections = 100 shared_buffers = 64000 # 500MB = 500 x ...
    AndyAndy
    Oct 10, 2005 at 8:40 am
    Oct 14, 2005 at 7:23 am
  • Hi, I have the following test setup: * PG 8.0.4 on Linux (Centos 4) compiled from source. * DB schema: essentially one table with a few int columns and one bytea column that stores blobs of 52000 ...
    Chris MairChris Mair
    Oct 25, 2005 at 1:49 pm
    Oct 31, 2005 at 2:29 pm
  • Hi, I'm trying to include a custom function in my SQL-queries, which unfortunately leaves the server hanging... I basically search through two tables: * TABLE_MAPPING: lists that 'abc' is mapped to ...
    Jan AertsJan Aerts
    Oct 3, 2005 at 3:14 pm
    Nov 7, 2005 at 8:42 pm
  • I have two tables, one is called 'users' the other is 'user_activity'. The 'users' table simply contains the users in the system there is about 30,000 rows. The 'user_activity' table stores the ...
    Collin PetersCollin Peters
    Oct 28, 2005 at 9:53 pm
    Oct 29, 2005 at 12:37 am
  • I tried on pgsql-general but got no reply. re-posting here as it's probably the best place to ask I'm having some significant performance problems with left join. Can anyone give me any pointers as ...
    Rich DoughtyRich Doughty
    Oct 25, 2005 at 11:35 am
    Oct 26, 2005 at 8:33 am
  • Hi, I'm wondering if the plpgsql code: PERFORM 1 FROM foo; IF FOUND THEN ... is any slower than: PERFORM 1 FROM foo LIMIT 1; IF FOUND THEN ... Seems like it _could_ be smart enough to know that 1) ...
    Karl O. PincKarl O. Pinc
    Oct 22, 2005 at 4:55 am
    Oct 24, 2005 at 4:40 am
  • I have an application that has a table that is both read and write intensive. Data from iostat indicates that the write speed of the system is the factor that is limiting performance. The table has ...
    Emil BriggsEmil Briggs
    Oct 5, 2005 at 1:09 am
    Oct 5, 2005 at 11:46 pm
  • The preliminaries: - PostgreSQL 8.1 beta 3, Debian experimental - database has been VACUUMed FULL ANALYZE. - a pg_dump -Fc exists at http://199.77.129.48/inet_test.db - ia32 hardware with 2 GB ...
    Robert EdmondsRobert Edmonds
    Oct 24, 2005 at 3:58 am
    Nov 2, 2005 at 4:20 am
  • Hi there. I have tried to implement the layered views as suggested earlier on one of the simplest queries (just to get a feel for it). And there seems to be something odd going on. Attached are all ...
    Svenne KrapSvenne Krap
    Oct 30, 2005 at 5:14 pm
    Oct 30, 2005 at 6:48 pm
  • what happend with postgresql 8.1b4 performance on query? please help me !!! look at this: select count(*) from fotos where archivo not in (select archivo from archivos) Aggregate ...
    Sidar López CruzSidar López Cruz
    Oct 26, 2005 at 4:26 am
    Oct 26, 2005 at 3:20 pm
  • Hi, is there an easy way to flush all cached query plans in pl/pgsql functions? I've long running sessions where data are changing and the plans become inaccurate after a while. I can imagine ...
    Kuba OuhrabkaKuba Ouhrabka
    Oct 20, 2005 at 2:07 pm
    Oct 21, 2005 at 7:33 am
  • Christian, Do you have foreign keys pointing to your table with ON CASCADE... ? Cause in that case you're not only deleting your 22000 records, but the whole tree of cascades. And if you don't have ...
    Csaba NagyCsaba Nagy
    Oct 20, 2005 at 8:50 am
    Oct 20, 2005 at 8:53 am
  • We are indexing about 5 million small documents using tsearch2/GIST. Each "document" contains 2 to 50 words. This is a "write once, read many" situation. Write performance is unimportant, and the ...
    Craig A. JamesCraig A. James
    Oct 14, 2005 at 10:33 pm
    Oct 18, 2005 at 6:21 am
  • I have a table in the databases I work with, that contains two text columns with XML data stored inside them. This table is by far the biggest table in the databases, and the text columns use up the ...
    StefStef
    Oct 10, 2005 at 12:19 pm
    Oct 11, 2005 at 8:03 am
  • Hello, just a little question, It's preferable to use Text Fields or varchar(255) fields in a table? Are there any performance differences in the use of any of them? Thanks a lot for your answer!
    Cristian PrietoCristian Prieto
    Oct 5, 2005 at 6:24 pm
    Oct 10, 2005 at 12:54 pm
  • What's the current status of how much faster the Opteron is compared to the Xeons? I know the Opterons used to be close to 2x faster, but is that still the case? I understand much work has been done ...
    Jeff FrostJeff Frost
    Oct 6, 2005 at 11:55 pm
    Oct 7, 2005 at 7:03 pm
  • Can anyone tell me what precisely a WAL buffer contains, so that I can compute an appropriate setting for wal_buffers (in 8.0.3)? I know the documentation suggests there is little evidence that ...
    Ian WestmacottIan Westmacott
    Oct 5, 2005 at 1:23 pm
    Oct 7, 2005 at 6:47 pm
  • I converted a db from MS SQL, where tables and fields were CamelCase, and just lowercased the ddl to create the tables. So table and fields names were all created in lowercase, but I didn't have to ...
    Roger HandRoger Hand
    Oct 1, 2005 at 7:51 pm
    Oct 5, 2005 at 9:10 am
  • I have a table that holds entries as in a ficticious table Log(id integer, msg text). Lets say then that I have the program log_tail that has as it´s sole purpose to print newly added data elements. ...
    Rodrigo MaderaRodrigo Madera
    Oct 28, 2005 at 9:39 pm
    Oct 31, 2005 at 1:47 pm
  • Is there a rule-of-thumb for determining the amount of system memory a database requres (other than "all you can afford")?
    PostgreSQLPostgreSQL
    Oct 27, 2005 at 7:31 pm
    Oct 28, 2005 at 2:02 pm
  • Is there something that tells postgres to take the resorces from computer (RAM, HDD, SWAP on linux) as it need, not modifying variables on postgresql.conf and other operating system things? A days ...
    Sidar López CruzSidar López Cruz
    Oct 27, 2005 at 2:25 pm
    Oct 27, 2005 at 10:52 pm
  • Hi All, Thank you very much for your help in configuring the database. Can you guys please take a look at the following query and let me know why the index is not considered in the plan? Here is the ...
    Kishore BKishore B
    Oct 25, 2005 at 8:47 am
    Oct 25, 2005 at 6:01 pm
  • Hello, I have a strange effect on upcoming structure : DEX_OBJ ---< DEX_STRUCT --- DEX_LIT DEX_OBJ : 100 records (#DOO_ID, DOO_NAME) DEX_STRUCT : 2,5 million records (#(DST_SEQ, FK_DOO_ID, ...
    Nörder-Tuitje, MarcusNörder-Tuitje, Marcus
    Oct 13, 2005 at 9:54 am
    Oct 14, 2005 at 7:40 am
  • Thank you for your reply. Does this apply to FreeBSD 5.4 or 6.0 on amd64 (or both)? regards Claus
    Claus GuttesenClaus Guttesen
    Oct 11, 2005 at 2:54 pm
    Oct 11, 2005 at 8:09 pm
  • I currently have an infrastructure that's based around SQL Server 2000. I'm trying to move some of the data over to Postgres, partly to reduce the load on the SQL Server machine and partly because ...
    Edward Di Geronimo Jr.Edward Di Geronimo Jr.
    Oct 26, 2005 at 8:33 pm
    Oct 27, 2005 at 2:35 pm
  • I want to correlate two index rows of different tables to find an offset so that table1.value = table2.value AND table1.id = table2.id + offset is true for a maximum number of rows. To achieve this, ...
    Katherine StoovsKatherine Stoovs
    Oct 19, 2005 at 2:52 pm
    Oct 26, 2005 at 10:48 pm
  • where can i find bests practices for tunning postgresql? Consigue aquí las mejores y mas recientes ofertas de trabajo en América Latina y USA: http://latam.msn.com/empleos/
    Sidar López CruzSidar López Cruz
    Oct 26, 2005 at 4:24 am
    Oct 26, 2005 at 6:07 pm
  • Does Creating Temporary table in a function and NOT dropping them affects the performance of the database? I choose Polesoft Lockspam to fight spam, and you? http://www.polesoft.com/refer.html
    Christian Paul B. CosinasChristian Paul B. Cosinas
    Oct 25, 2005 at 7:24 am
    Oct 26, 2005 at 6:01 am
  • If I turn on stats_command_string, how much impact would it have on PostgreSQL server's performance during a period of massive data INSERTs? I know that the answer to the question I'm asking will ...
    JnevansJnevans
    Oct 20, 2005 at 8:39 pm
    Oct 25, 2005 at 5:02 pm
  • We are reindexing frequently, and I'm wondering if this is really necessary, given that it appears to take an exclusive lock on the table. Our table in question is vacuumed every 4 minutes, and we ...
    Markus BenneMarkus Benne
    Oct 25, 2005 at 1:56 pm
    Oct 25, 2005 at 2:27 pm
  • Hello! I've got a table BOARD_MESSAGE (message_id int8, thread_id int8, ...) with pk on message_id and and a non_unique not_null index on thread_id. A count(*) on BOARD_MESSAGE currently yields a ...
    Markus WollnyMarkus Wollny
    Oct 25, 2005 at 9:48 am
    Oct 25, 2005 at 1:44 pm
Group Navigation
period‹ prev | Oct 2005 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions66
posts479
users117
websitepostgresql.org
irc#postgresql

117 users for October 2005

Tom Lane: 46 posts Steinar H. Gunderson: 24 posts Jim C. Nasby: 20 posts Merlin Moncure: 19 posts Richard Huxton: 16 posts Ron Peacetree: 14 posts Alex Turner: 11 posts Christian Paul B. Cosinas: 11 posts Josh Berkus: 10 posts PostgreSQL: 10 posts Csaba Nagy: 9 posts Andy: 8 posts Mark: 7 posts Christopher Kings-Lynne: 7 posts Craig A. James: 7 posts Michael Fuhr: 7 posts Michael Stone: 7 posts Emil Briggs: 6 posts Kishore B: 6 posts Luke Lonergan: 6 posts
show more
Archives