Thread: 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 real 28m42.437s real 28m33.411s real 28m28.136s 8.4rc1 real 28m46.542s real 29m10.575s real 28m44.006s 8.3.0 real 23m39.131s real 23m40.655s real 23m49.458s Thanks, -- Toshihiro Kitagawa <kitagawa@sraoss.co.jp> SRA OSS, Inc. Japan
Toshihiro Kitagawa <kitagawa@sraoss.co.jp> wrote: > - shared_buffers = 128MB What happens with a larger value for shared_buffers? -Kevin
"Kevin Grittner" <Kevin.Grittner@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 real 31m13.873s real 30m17.180s real 29m16.170s - 8.4rc2 real 29m46.035s real 28m31.467s real 29m5.781s - 8.4rc1 real 29m35.403s real 28m44.221s real 29m20.309s - 8.3.0 real 31m10.434s real 32m39.912s real 32m8.221s * Shared_buffers = 512MB - 8.4.0 real 28m37.817s real 29m44.449s real 28m10.886s - 8.4rc2 real 28m0.657s real 29m50.888s real 28m28.037s - 8.4rc1 real 28m58.592s real 28m25.756s real 30m11.641s - 8.3.0 real 23m59.923s real 24m13.717s real 24m40.246s Regards, -- Toshihiro Kitagawa <kitagawa@sraoss.co.jp> SRA OSS, Inc. Japan