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(at)2ndQuadrant(dot)com Baltimore, MD
Comprehensive and Customized PostgreSQL Training Classes:
http://www.2ndquadrant.us/postgresql-training/