Re: import performance

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

 



[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



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

  Powered by Linux