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 un
On Mon, Nov 24, 2008 at 9:40 PM, Greg Smith <[EMAIL PROTECTED]> wrote:
> On Mon, 24 Nov 2008, Scott Marlowe wrote:
>
>> My guess is that the period of time for which pg_buffercache takes locks
>> on the buffer map are short enough that it isn't a real big deal on a fast
>> enough server.
>
> As the
On Mon, 24 Nov 2008, Scott Marlowe wrote:
My guess is that the period of time for which pg_buffercache takes locks
on the buffer map are short enough that it isn't a real big deal on a
fast enough server.
As the server involved gets faster, the amount of time the locks are
typically held for
On Mon, 24 Nov 2008, Kevin Kempter wrote:
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;
This query isn't going to save the information you need to figure out if
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
>> loa
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 15
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(*)
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,
>
