Re: import performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux