On Wed, Oct 10, 2012 at 10:11:30AM +0200, Julien Cigar wrote: > On 10/10/2012 09:12, Strahinja Kustudić wrote: > >Hi everyone, > > Hello, > > > > >I have a Postgresql 9.1 dedicated server with 16 cores, 96GB RAM > >and RAID10 15K SCSI drives which is runing Centos 6.2 x64. This > >server is mainly used for inserting/updating large amounts of data > >via copy/insert/update commands, and seldom for running select > >queries. > > > >Here are the relevant configuration parameters I changed: > > > >shared_buffers = 10GB > > Generally going over 4GB for shared_buffers doesn't help.. some of > the overhead of bgwriter and checkpoints is more or less linear in > the size of shared_buffers .. > > >effective_cache_size = 90GB > > effective_cache_size should be ~75% of the RAM (if it's a dedicated server) Why guess? Use 'free' to tell you the kernel cache size: http://momjian.us/main/blogs/pgblog/2012.html#May_4_2012 -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
