Message-ID: <490A71BD.7070303@frostconsultingllc.com>
Date: Thu, 30 Oct 2008 19:47:25 -0700
From: Jeff Frost <jeff@frostconsultingllc.com>
Organization: Frost Consulting, LLC
User-Agent: Thunderbird 2.0.0.17 (Windows/20080914)
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: pgsql-performance@postgresql.org
Subject: Re: Index usage problem on 8.3.3
References: <490A4EBE.9030804@frostconsultingllc.com>
	<13272.1225413116@sss.pgh.pa.us>
	<490A56C1.8020804@frostconsultingllc.com>
	<14519.1225415657@sss.pgh.pa.us>
	<490A5DCB.9060403@frostconsultingllc.com>
	<14766.1225416478@sss.pgh.pa.us>
	<Pine.LNX.4.64.0810301843201.17153@discord.home.frostconsultingllc.com>
	<15839.1225418158@sss.pgh.pa.us>
In-Reply-To: <15839.1225418158@sss.pgh.pa.us>
Content-Type: multipart/alternative;
	boundary="------------030407080108040403050904"

This is a multi-part message in MIME format.
--------------030407080108040403050904
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit


Tom Lane wrote:
> Jeff Frost <jeff@frostconsultingllc.com> writes:
>   
>> On Thu, 30 Oct 2008, Tom Lane wrote:
>>     
>>>> Any idea why I don't see it on 8.3.4?
>>>>         
>>> I think it's more likely some small difference in your test conditions
>>> than any real version-to-version difference.  In particular I think the
>>> "still see" test might be influenced by the ages of transactions running
>>> concurrently.
>>>       
>
>   
>> Interesting.  This is on a test server which has no other concurrent 
>> transactions and it acts the same way after I stopped 8.3.4 and started up 
>> 8.3.3 again as it did before stopping 8.3.3 to bring up 8.3.4.  Hrmm..I'm not 
>> sure that makes sense.  So, I did the test with the sql script on 8.3.3, then 
>> shut down 8.3.3, started up 8.3.4 on the same data dir, ran the test 
>> successfully.  Next I shut down 8.3.4 and started 8.3.3 and verified that the 
>> behavior was still the same on 8.3.3.  I wonder what else I might be doing 
>> differently.
>>     
>
> Huh.  That does sound like it's a version-to-version difference.
> There's nothing in the CVS log that seems related though.  Are you
> willing to post your test case?
> 	
>   
It's a customer DB, so I'll contact them and see if we can boil it down
to a test case with no sensitive data.

-- 
Jeff Frost, Owner 	<jeff@frostconsultingllc.com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 916-647-6411	FAX: 916-405-4032


--------------030407080108040403050904
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
<br>
Tom Lane wrote:
<blockquote cite="mid:15839.1225418158@sss.pgh.pa.us" type="cite">
  <pre wrap="">Jeff Frost <a class="moz-txt-link-rfc2396E" href="mailto:jeff@frostconsultingllc.com">&lt;jeff@frostconsultingllc.com&gt;</a> writes:
  </pre>
  <blockquote type="cite">
    <pre wrap="">On Thu, 30 Oct 2008, Tom Lane wrote:
    </pre>
    <blockquote type="cite">
      <blockquote type="cite">
        <pre wrap="">Any idea why I don't see it on 8.3.4?
        </pre>
      </blockquote>
      <pre wrap="">I think it's more likely some small difference in your test conditions
than any real version-to-version difference.  In particular I think the
"still see" test might be influenced by the ages of transactions running
concurrently.
      </pre>
    </blockquote>
  </blockquote>
  <pre wrap=""><!---->
  </pre>
  <blockquote type="cite">
    <pre wrap="">Interesting.  This is on a test server which has no other concurrent 
transactions and it acts the same way after I stopped 8.3.4 and started up 
8.3.3 again as it did before stopping 8.3.3 to bring up 8.3.4.  Hrmm..I'm not 
sure that makes sense.  So, I did the test with the sql script on 8.3.3, then 
shut down 8.3.3, started up 8.3.4 on the same data dir, ran the test 
successfully.  Next I shut down 8.3.4 and started 8.3.3 and verified that the 
behavior was still the same on 8.3.3.  I wonder what else I might be doing 
differently.
    </pre>
  </blockquote>
  <pre wrap=""><!---->
Huh.  That does sound like it's a version-to-version difference.
There's nothing in the CVS log that seems related though.  Are you
willing to post your test case?
	
  </pre>
</blockquote>
It's a customer DB, so I'll contact them and see if we can boil it down
to a test case with no sensitive data.<br>
<pre class="moz-signature" cols="72">-- 
Jeff Frost, Owner 	<a class="moz-txt-link-rfc2396E" href="mailto:jeff@frostconsultingllc.com">&lt;jeff@frostconsultingllc.com&gt;</a>
Frost Consulting, LLC 	<a class="moz-txt-link-freetext" href="http://www.frostconsultingllc.com/">http://www.frostconsultingllc.com/</a>
Phone: 916-647-6411	FAX: 916-405-4032
</pre>
</body>
</html>

--------------030407080108040403050904--