> I tried work_mem and maintenance_work_mem but it does not seem to make much > difference yet. Admittedly I had set it to 100M and 80M, so after reading a > little bit more I have found that I could easily set it to several GBs. But > I am not sure those are the correct config parameters to use for this. I > havent found any others that are relevant so far.
You probably want to increase shared_buffers by quite a large amount and maybe make work_mem not quite so big. If you have 2GB of memory you might set shared_buffers to 1GB, work_mem 16MB, maintenance_work_mem 64MB? ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
