Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id EE8289F9F7B
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 15 Dec 2006 14:26:43 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024)
	with ESMTP id 98894-05 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 15 Dec 2006 14:26:31 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.234])
	by postgresql.org (Postfix) with ESMTP id 620869F9398
	for <pgsql-performance@postgresql.org>;
	Fri, 15 Dec 2006 14:26:32 -0400 (AST)
Received: by wx-out-0506.google.com with SMTP id i28so786173wxd
	for <pgsql-performance@postgresql.org>;
	Fri, 15 Dec 2006 10:26:31 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=izfQgJg5lEw8f0Zdz/7M1CwMpTm2LOSPnF9XSkZ7H2Ft/q36DLsw7sdT48h3B6wyp35A+pt0Cfv4CLVvEaVsMFTJWHAQd29bF2Mcf9Koc9A9RChZT2XRreaaQzY6NC1FrO4qenq65MPBbiDjh174Im3qyr1sEsWOqqi0qFeduxk=
Received: by 10.70.38.12 with SMTP id l12mr1563636wxl.1166207191354;
	Fri, 15 Dec 2006 10:26:31 -0800 (PST)
Received: by 10.70.108.15 with HTTP; Fri, 15 Dec 2006 10:26:31 -0800 (PST)
Message-ID: <357fa7590612151026t4ae033f6w5367cac9d0b67064@mail.gmail.com>
Date: Fri, 15 Dec 2006 13:26:31 -0500
From: "Steven Flatt" <steven.flatt@gmail.com>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Subject: Re: Insertion to temp table deteriorating over time
Cc: pgsql-performance@postgresql.org
In-Reply-To: <12508.1166206006@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_176182_8913021.1166207191273"
References: <357fa7590612130844q58ef3ca5q31e164f9b006e0fc@mail.gmail.com>
	<9315.1166030958@sss.pgh.pa.us>
	<357fa7590612131517q375fc0by50cb4257bcce7a94@mail.gmail.com>
	<13032.1166052447@sss.pgh.pa.us>
	<357fa7590612141240t55e70695q770a05a68a67536c@mail.gmail.com>
	<25209.1166131396@sss.pgh.pa.us>
	<357fa7590612150821i3eca3f66ge2ced1ee20fa2dac@mail.gmail.com>
	<11651.1166202586@sss.pgh.pa.us>
	<357fa7590612150955g1b9c733duaf000c23d28aa8af@mail.gmail.com>
	<12508.1166206006@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200612/425
X-Sequence-Number: 22481

------=_Part_176182_8913021.1166207191273
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Good question, and I agree with your point.

Are the removable rows in pg_class even an issue?  So what if 5000-6000 dead
tuples are generated every hour then vacuumed?  Performance continues to
steadily decline over a few days time.  Memory usage does not appear to be
bloating.  Open file handles remain fairly fixed.  Is there anything else I
can monitor (perhaps something to do with the odbc connection) that I could
potentially correlate with the degrading performance?

Steve


On 12/15/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Oh, then where *are* the removable rows coming from?  At this point I
> think that the truncate/refill thing is not the culprit, or at any rate
> is only one part of a problematic usage pattern that we don't see all of
> yet.
>
>                        regards, tom lane
>

------=_Part_176182_8913021.1166207191273
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Good question, and I agree with your point.</div>
<div>&nbsp;</div>
<div>Are the removable rows in pg_class even an issue?&nbsp; So what if 5000-6000 dead tuples are generated every hour then vacuumed?&nbsp; Performance continues to steadily decline over a few days time.&nbsp; Memory usage does not appear to be bloating.&nbsp; Open file handles remain fairly fixed.&nbsp; Is there anything else I can monitor (perhaps something to do with the odbc connection) that I could potentially correlate with the degrading performance?
</div>
<div>&nbsp;</div>
<div>Steve<br><br>&nbsp;</div>
<div><span class="gmail_quote">On 12/15/06, <b class="gmail_sendername">Tom Lane</b> &lt;<a href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Oh, then where *are* the removable rows coming from?&nbsp;&nbsp;At this point I<br>think that the truncate/refill thing is not the culprit, or at any rate
<br>is only one part of a problematic usage pattern that we don't see all of<br>yet.<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; regards, tom lane<br></blockquote></div><br>

------=_Part_176182_8913021.1166207191273--