Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 5B76B9FA373 for ; Thu, 14 Dec 2006 17:23:26 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 72785-04 for ; Thu, 14 Dec 2006 17:23:20 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id CADD19FA344 for ; Thu, 14 Dec 2006 17:23:20 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id kBELNG3E025210; Thu, 14 Dec 2006 16:23:16 -0500 (EST) To: "Steven Flatt" cc: pgsql-performance@postgresql.org Subject: Re: Insertion to temp table deteriorating over time In-reply-to: <357fa7590612141240t55e70695q770a05a68a67536c@mail.gmail.com> 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> Comments: In-reply-to "Steven Flatt" message dated "Thu, 14 Dec 2006 15:40:24 -0500" Date: Thu, 14 Dec 2006 16:23:16 -0500 Message-ID: <25209.1166131396@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/388 X-Sequence-Number: 22444 "Steven Flatt" writes: > Regarding your other email -- interesting -- but we are vacuuming pg_class > every hour. So I don't think the answer lies there... That's good, but is the vacuum actually accomplishing anything? I'm wondering if there's also a long-running transaction in the mix. Try a manual "VACUUM VERBOSE pg_class;" after the thing has slowed down, and see what it says about removable and nonremovable rows. regards, tom lane