Jim C. Nasby said: > Well, that certainly won't help things... at a minimum, on your machine, > you should change the following: > shared_buffers=10000 > effective_cache_size=100000 > > The following should also help: > work_mem=10000 > vacuum_cost_delay=50 > autovacuum=on > autovacuum_vacuum_scale_factor=0.2
Jim, I just want to say thanks for providing these tuning parameters. I not currently using your product, but I hope to in the near future for a larger scale version of my own product. Performance tuning is something of an arcane art from my perspective, so getting any help on it is highly desirable. Clay Dowling -- Simple Content Management http://www.ceamus.com