tv@xxxxxxxx writes: >> Second, I modified the work_mem setting to 2GB (reloaded config) and I see >> a response time of 38 seconds. Results below from EXPLAIN ANALYZE: > How did you reload the config? Using 'kill -HUP pid'? That should work > fine. Have you cheched 'work_mem' after the reload? > Because the explain plans are exactly the same (structure, estimated > costs). The really interesting bit is this and it did not change at all > Buckets: 1024 Batches: 64 Memory Usage: 650kB If that didn't change, I'm prepared to bet that the OP didn't actually manage to change the active value of work_mem. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
