Re: [PERFORM] executor stats / page reclaims

2010-12-03 Thread Robert Haas
On Thu, Nov 18, 2010 at 5:10 AM, Uwe Bartels wrote: > I'm experiencing extremely different response times for some complex pgsql > functions. extremly different means from 20ms - 500ms and up to 20s. > I have to say that the complete database fits in memory (64GB). > shared_buffers is set to 16GB.

[PERFORM] executor stats / page reclaims

2010-11-18 Thread Uwe Bartels
Hi, I'm experiencing extremely different response times for some complex pgsql functions. extremly different means from 20ms - 500ms and up to 20s. I have to say that the complete database fits in memory (64GB). shared_buffers is set to 16GB. the rest ist used by thefs cache and conections/work_me