Re: [HACKERS] Did COPY performance regression solve in 8.4rc2?

2009-07-05 Thread Toshihiro Kitagawa 
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?

2009-07-01 Thread Toshihiro Kitagawa 
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

Re: [HACKERS] Did COPY performance regression solve in 8.4rc2?

2009-07-01 Thread Kevin Grittner 
Toshihiro Kitagawa kitag...@sraoss.co.jp wrote: 
 
 - shared_buffers = 128MB
 
What happens with a larger value for shared_buffers?
 
-Kevin

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers