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 3ACB5D1D290 for ; Wed, 21 Apr 2004 00:29:13 -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 56163-02 for ; Wed, 21 Apr 2004 00:29:11 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 61BFDD1BB64 for ; Wed, 21 Apr 2004 00:29:11 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i3L3T2Bj025436; Tue, 20 Apr 2004 23:29:03 -0400 (EDT) To: "Matthew T. O'Connor" Cc: "Thomas Swan" , "Bruce Momjian" , "Jeff Boes" , "PostgreSQL-development" Subject: Re: pg_autovacuum crashes when query fails for temp In-reply-to: <37398.192.154.91.225.1082485149.squirrel@192.154.91.225> References: <200404201525.i3KFPp809934@candle.pha.pa.us> <40855DF0.3010300@idigx.com> <37398.192.154.91.225.1082485149.squirrel@192.154.91.225> Comments: In-reply-to "Matthew T. O'Connor" message dated "Tue, 20 Apr 2004 14:19:09 -0400" Date: Tue, 20 Apr 2004 23:29:02 -0400 Message-ID: <25435.1082518142@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/602 X-Sequence-Number: 52524 "Matthew T. O'Connor" writes: >> Bruce Momjian wrote: >> Should pg_autovacuum be vacuuming temporary tables? > This is a good question, and I would like some opinions from some other > people more informed than I. You *can not* vacuum other sessions' temp tables; you don't have access to the data. (You have no way to get at pages that are modified in someone else's local buffer manager.) You could vacuum your own temp tables, if you had any, but I would hardly expect autovacuum to have any. In reference to Chris' followup question, you *should* be vacuuming system catalogs, and you *should not* be vacuuming TOAST tables. VACUUM on a regular table automatically hits the associated TOAST table. regards, tom lane