Scott Marlowe wrote:
On Mon, Nov 24, 2008 at 12:52 PM, Brad Nicholson
[EMAIL PROTECTED] wrote:
I just ran it in a loop over and over on my 8 core opteron server and
it ran the load factor up by almost exactly 1.0. Under our normal
daily load, it sits at 1.9 to 2.5, and it climbed to 2.9
Hi All;
I've installed pg_buffercache and I want to use it to help define the optimal
shared_buffers size.
Currently I run this each 15min via cron:
insert into buffercache_stats select now(), isdirty, count(*) as buffers,
(count(*) * 8192) as memory from pg_buffercache group by 1,2;
and
On Mon, 2008-11-24 at 11:43 -0700, Kevin Kempter wrote:
Hi All;
I've installed pg_buffercache and I want to use it to help define the optimal
shared_buffers size.
Currently I run this each 15min via cron:
insert into buffercache_stats select now(), isdirty, count(*) as buffers,
On Mon, Nov 24, 2008 at 11:43 AM, Kevin Kempter
[EMAIL PROTECTED] wrote:
Hi All;
I've installed pg_buffercache and I want to use it to help define the optimal
shared_buffers size.
Currently I run this each 15min via cron:
insert into buffercache_stats select now(), isdirty, count(*) as
On Mon, 2008-11-24 at 12:46 -0700, Scott Marlowe wrote:
On Mon, Nov 24, 2008 at 11:43 AM, Kevin Kempter
[EMAIL PROTECTED] wrote:
Hi All;
I've installed pg_buffercache and I want to use it to help define the
optimal
shared_buffers size.
Currently I run this each 15min via cron:
On Mon, Nov 24, 2008 at 12:52 PM, Brad Nicholson
[EMAIL PROTECTED] wrote:
I just ran it in a loop over and over on my 8 core opteron server and
it ran the load factor up by almost exactly 1.0. Under our normal
daily load, it sits at 1.9 to 2.5, and it climbed to 2.9 under the new
load of