"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 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 <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
