Re: import performance - Mailing list pgsql-performance

From Gavin Sherry
Subject Re: import performance
Date
Msg-id Pine.LNX.4.58.0603141159210.16412@linuxworld.com.au
Whole thread Raw
In response to Re: import performance  ("Dave Dutcher" <dave@tridecap.com>)
List pgsql-performance
On Mon, 13 Mar 2006, Dave Dutcher wrote:

> [Snip]
> > >
> > > shared_buffers = 256
> >
> > Make this higher too. If this is a dedicated machine with 512 MB of
> ram,
> > set it to something like 125000.
> >
> > You may need to adjust shared memory settings for your operating
> system.
> > See the manual for details.
> >
>
> Whoa.  Maybe I'm wrong, but isn't each buffer 8192 bytes?  So you are
> suggesting that he set his shared buffers to a gigabyte on a machine
> with 512 MB of ram?  Or was that just a miscalculation?

One to many zeros. Oops.

Gavin

pgsql-performance by date:

Previous
From: "Dave Dutcher"
Date:
Subject: Re: import performance
Next
From: Chris
Date:
Subject: Re: import performance