Re: [HACKERS] Did COPY performance regression solve in 8.4rc2?
Kevin Grittner kevin.gritt...@wicourts.gov wrote: - shared_buffers = 128MB What happens with a larger value for shared_buffers? COPY performance of PostgreSQL 8.4.0 was a little bit better than PostgreSQL 8.3.0 when shared_buffes was 1GB. My server has 2GB RAM. * Shared_buffers = 1GB - 8.4.0 real31m13.873s real30m17.180s real29m16.170s - 8.4rc2 real29m46.035s real28m31.467s real29m5.781s - 8.4rc1 real29m35.403s real28m44.221s real29m20.309s - 8.3.0 real31m10.434s real32m39.912s real32m8.221s * Shared_buffers = 512MB - 8.4.0 real28m37.817s real29m44.449s real28m10.886s - 8.4rc2 real28m0.657s real29m50.888s real28m28.037s - 8.4rc1 real28m58.592s real28m25.756s real30m11.641s - 8.3.0 real23m59.923s real24m13.717s real24m40.246s Regards, -- Toshihiro Kitagawa kitag...@sraoss.co.jp SRA OSS, Inc. Japan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] Did COPY performance regression solve in 8.4rc2?
COPY performance issue is discussed in the following threads, and it seems the conclusion was 8.4rc2 has been improved. http://archives.postgresql.org/pgsql-hackers/2009-06/msg01133.php However, I didn't see difference of COPY performance between 8.4rc1 and 8.4rc2. It seems that a COPY to 8.4rc1 or 8.4rc2 using pgbench takes about 20% longer than it does to 8.3.0. * Test environment - HP Proliant DL145 G3 - CentOS 5 x86_64 (kernel 2.6.18-8.1.8.el5) * Test method $ initdb --no-locale --encoding=UTF8 $ pg_ctl -w start $ time pgbench -i -s 1000 * Changes of postgresql.conf - max_connections = 200 - shared_buffers = 128MB - logging_collector = on - silent_mode = on * results 8.4rc2 real28m42.437s real28m33.411s real28m28.136s 8.4rc1 real28m46.542s real29m10.575s real28m44.006s 8.3.0 real23m39.131s real23m40.655s real23m49.458s Thanks, -- Toshihiro Kitagawa kitag...@sraoss.co.jp SRA OSS, Inc. Japan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers