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