On 06/28/2011 07:26 PM, Craig McIlwee wrote:
Yes, the data import is painfully slow but I hope to make up for that
with the read performance later.
You can probably improve that with something like this:
shared_buffers=512MB
checkpoint_segments=64
Maybe bump up maintenance_work_mem too, if the vacuum part of that is
the painful one.
--
Greg Smith 2ndQuadrant US greg@xxxxxxxxxxxxxxx Baltimore, MD
Comprehensive and Customized PostgreSQL Training Classes:
http://www.2ndquadrant.us/postgresql-training/
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
