DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type;
	b=SHn0D6AUa4pPJaRQH3mtGOUSENUgbPUSSF/wqoq/zAxcLiK7Se/UwqymBnWvKvByN8O6ts+u+hM1/Lpid5RAXOMwx7rvR+3J+74r4rMDs6YjjlNQnXBUxxKm5/4Bv2T21I8F7sdC6Q+NfIDi5fao12fLlzD0A2CoZaMwBgpwE04=;
Message-ID: <466107.20499.qm@web65410.mail.ac4.yahoo.com>
References: <293254.80548.qm@web65413.mail.ac4.yahoo.com>
	<201011011514.32217.andres@anarazel.de>
	<521708.74664.qm@web65403.mail.ac4.yahoo.com>
	<201011011521.00144.andres@anarazel.de>
Date: Mon, 1 Nov 2010 07:28:19 -0700 (PDT)
From: Divakar Singh <dpsmails@yahoo.com>
Subject: Re: Insert performance with composite index
To: Andres Freund <andres@anarazel.de>
Cc: pgsql-performance@postgresql.org
In-Reply-To: <201011011521.00144.andres@anarazel.de>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1111224550-1288621699=:20499"

--0-1111224550-1288621699=:20499
Content-Type: text/plain; charset=us-ascii

Do you mean these parameters have been removed starting 9.X?
As I see on 
http://www.network-theory.co.uk/docs/postgresql/vol3/BackgroundWriter.html 
,these parameters were added starting from 8.0 right?


 Best Regards,
Divakar


________________________________
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...

Andres


--0-1111224550-1288621699=:20499
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:10pt">Do you mean these parameters have been removed starting 9.X?<br><span>As I see on <a target="_blank" href="http://www.network-theory.co.uk/docs/postgresql/vol3/BackgroundWriter.html">http://www.network-theory.co.uk/docs/postgresql/vol3/BackgroundWriter.html</a> ,these parameters were added starting from 8.0 right?</span><br><br><div>&nbsp;</div>Best Regards,<br>Divakar<div><br></div><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><br><div style="font-family: verdana,helvetica,sans-serif; font-size: 10pt;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Andres Freund &lt;andres@anarazel.de&gt;<br><b><span style="font-weight: bold;">To:</span></b> Divakar Singh &lt;dpsmails@yahoo.com&gt;<br><b><span style="font-weight: bold;">Cc:</span></b>
 pgsql-performance@postgresql.org<br><b><span style="font-weight: bold;">Sent:</span></b> Mon, November 1, 2010 7:50:59 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [PERFORM] Insert performance with composite index<br></font><br>On Monday 01 November 2010 15:16:49 Divakar Singh wrote:<br>&gt; I am using 9.0.1<br>Either thats not true or you cargo culted loads of your config from a <br>significantly older pg version.<br><br>Things like:<br><br>#bgwriter_delay = 200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; # 10-10000 milliseconds between rounds<br>bgwriter_lru_percent = 0&nbsp; &nbsp; &nbsp; &nbsp; # 0-100% of LRU buffers scanned/round<br>#bgwriter_lru_maxpages = 5&nbsp; &nbsp; &nbsp; &nbsp; # 0-1000 buffers max written/round<br>#bgwriter_all_percent = 0.333&nbsp; &nbsp; &nbsp; &nbsp; # 0-100% of all buffers scanned/round<br>bgwriter_all_maxpages = 0&nbsp; &nbsp; &nbsp; &nbsp; # 0-1000 buffers max written/round<br><br>make me very
 suspicious.<br><br>As I said, I would check the variables I referenced in my first post...<br><br>Andres<br></div></div>
</div><br>

      </body></html>
--0-1111224550-1288621699=:20499--