SEO

#1 (**permalink**) 04-19-2008, 07:16 AM

[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?

Dave

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

#2 (**permalink**) 04-19-2008, 07:16 AM

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Re: import performance