From: Andres Freund <andres@anarazel.de> To: Divakar Singh <dpsmails@yahoo.com> Cc: pgsql-performance@postgresql.org Sent: Mon, November 1, 2010 7:50:59 PM Subject: Re: [PERFORM] Insert performance with composite index
On Monday 01 November 2010 15:16:49 Divakar Singh wrote: > I am using 9.0.1 Either thats not true or you cargo culted loads of your config from a significantly older pg version.
Things like:
#bgwriter_delay = 200 # 10-10000 milliseconds between rounds bgwriter_lru_percent = 0 # 0-100% of LRU buffers scanned/round #bgwriter_lru_maxpages = 5 # 0-1000 buffers max written/round #bgwriter_all_percent = 0.333 # 0-100% of all buffers scanned/round bgwriter_all_maxpages = 0 # 0-1000 buffers max written/round
make me very suspicious.
As I said, I would check the variables I referenced in my first post...