On Wed, 2007-10-10 at 19:49 -0500, Scott Marlowe wrote:
> On 10/10/07, Radhika S <[EMAIL PROTECTED]> wrote:
> > Thank you scott.
> >
> > We plan on upgrading to Postgres 8.2 very soon.
> > Would it be safe to say I can make my SHARED BUFFER setting 200MB (I have
> > 2GB memory ).
> > The default i
On 10/10/07, Radhika S <[EMAIL PROTECTED]> wrote:
> Thank you scott.
>
> We plan on upgrading to Postgres 8.2 very soon.
> Would it be safe to say I can make my SHARED BUFFER setting 200MB (I have
> 2GB memory ).
> The default is 24MB.
On a dedicated db machine with 2 Gigs of ram 500Meg is fine.
Thank you scott.
We plan on upgrading to Postgres 8.2 very soon.
Would it be safe to say I can make my SHARED BUFFER setting 200MB (I have
2GB memory ).
The default is 24MB.
Regds,
Radhika
On 10/10/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
>
> On 10/9/07, Radhika S <[EMAIL PROTECTED]> wrote:
On 10/10/07, Josh Trutwin <[EMAIL PROTECTED]> wrote:
> On Wed, 10 Oct 2007 10:20:02 -0500
> "Scott Marlowe" <[EMAIL PROTECTED]> wrote:
>
> > In 7.4, using 25% is often too high a setting for it to handle well,
> > and the practical useful maximum is usually under 10,000
> > shared_buffers, and ofte
On Wed, 10 Oct 2007 10:20:02 -0500
"Scott Marlowe" <[EMAIL PROTECTED]> wrote:
> In 7.4, using 25% is often too high a setting for it to handle well,
> and the practical useful maximum is usually under 10,000
> shared_buffers, and often closer to 1,000 to 5,000
Scott - interesting reply. Is this
On 10/9/07, Radhika S <[EMAIL PROTECTED]> wrote:
> Hi,
> Along with my previous message (slow postgres), I notice the shared buffer
> setting for our production database is set to 1000.
> How much higher can I go? I don't know how much my kernel can take?
>
> I am running postgres 7.4.6 on Redhat
On 10/9/07, Radhika S <[EMAIL PROTECTED]> wrote:
> Hi,
> Along with my previous message (slow postgres), I notice the shared buffer
> setting for our production database is set to 1000.
> How much higher can I go? I don't know how much my kernel can take?
A lot higher. How much memory do you have
Hi,
Along with my previous message (slow postgres), I notice the shared buffer
setting for our production database is set to 1000.
How much higher can I go? I don't know how much my kernel can take?
I am running postgres 7.4.6 on Redhat enterprise 3 server.
Thanks,
Radhika
--
It is all a matte
