Re: [PERFORM] does the query planner consider work_mem?

2012-05-30 Thread Murat Tasan
rk_mem to a full 16 MB this time. does anyone know how to resolve this? or should i even worry about it? On Wed, May 30, 2012 at 2:25 PM, Ants Aasma wrote: > On Wed, May 30, 2012 at 8:57 PM, Murat Tasan wrote: >> any insights here? > > Have you tried running the slow option multip

[PERFORM] does the query planner consider work_mem?

2012-05-30 Thread Murat Tasan
hi all - i'm having a bit of trouble with some queries that are running painfully slowly after migrating my database from one machine using PostgreSQL 8.2 to another machine with PostgreSQL 8.4. as far as i can tell, the two *servers* (not the physical machines) are set up pretty close to identical