Re: Did COPY performance regression solve in 8.4rc2?

"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)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(at)sraoss(dot)co(dot)jp>
SRA OSS, Inc. Japan