>> 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
In response to
pgsql-performance by date
|Next:||From: Robert Haas||Date: 2010-11-21 18:55:54|
|Subject: Re: Query Performance SQL Server vs. Postgresql|
|Previous:||From: Alvaro Herrera||Date: 2010-11-21 16:25:37|
|Subject: Re: autovacuum blocks the operations of other manual vacuum|