X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 947E1D1D067 for ; Wed, 21 Apr 2004 08:59:50 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 30549-01 for ; Wed, 21 Apr 2004 08:59:50 -0300 (ADT) Received: from outbound.mailhop.org (outbound.mailhop.org [63.208.196.171]) by svr1.postgresql.org (Postfix) with ESMTP id 3CF0CD1CCAB for ; Wed, 21 Apr 2004 08:59:47 -0300 (ADT) Received: from ool-4352919e.dyn.optonline.net ([67.82.145.158] helo=zedora) by outbound.mailhop.org with asmtp (TLSv1:RC4-MD5:128) (Exim 4.20) id 1BGGOG-0007Cr-M5; Wed, 21 Apr 2004 07:59:45 -0400 From: "Matthew T. O'Connor" To: Christopher Kings-Lynne Subject: Re: pg_autovacuum crashes when query fails for temp tables Date: Wed, 21 Apr 2004 07:59:45 -0400 User-Agent: KMail/1.6.1 Cc: Bruce Momjian , Jeff Boes , PostgreSQL-development References: <200404201650.i3KGoGZ27739@candle.pha.pa.us> <4085EEDE.9050306@zeut.net> <4085F306.3050504@familyhealth.com.au> In-Reply-To: <4085F306.3050504@familyhealth.com.au> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200404210759.45556.matthew@zeut.net> X-Mail-Handler: MailHop Outbound by DynDNS.org X-Report-Abuse-To: abuse@dyndns.org X-MHO-User: zeut X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=RCVD_IN_NJABL, RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200404/614 X-Sequence-Number: 52536 On Wednesday 21 April 2004 12:05 am, Christopher Kings-Lynne wrote: > >> No, I have not heard of a 7.4.3 timeline, but we certainly want your > >> eventual fixes in that release. > > > > Right, and along these lines there are a few other pg_autovacuum bugs > > that were fixed just after 7.4.2. > > A rollable log solution would be nice :) Syslog? :) Agreed, but I don't see that being added into the 7.4 release, I think the patch would be bounced if I tried it. For 7.5 pg_autovacumm will be integrated in to the backend allowing the use of the logging functions already available there. Matthew