X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 06E0E5348C for ; Fri, 25 Mar 2005 23:18:12 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 98954-03 for ; Fri, 25 Mar 2005 23:18:11 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id A30595341B for ; Fri, 25 Mar 2005 23:18:10 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j2PNID1W016181; Fri, 25 Mar 2005 18:18:13 -0500 (EST) To: Bruce Momjian Cc: "Matthew T. O'Connor" , Otto Blomqvist , "pgsql-performance@postgresql.org" Subject: Re: pg_autovacuum not having enough suction ? In-reply-to: <200503252313.j2PNDFA24795@candle.pha.pa.us> References: <200503252313.j2PNDFA24795@candle.pha.pa.us> Comments: In-reply-to Bruce Momjian message dated "Fri, 25 Mar 2005 18:13:15 -0500" Date: Fri, 25 Mar 2005 18:18:13 -0500 Message-ID: <16180.1111792693@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/572 X-Sequence-Number: 11277 Bruce Momjian writes: > Tom Lane wrote: >> I'm not sure if autovacuum could be taught to do that --- it could >> perhaps launch a vacuum as soon as it notices a large fraction of the >> table got deleted, but do we really want to authorize it to launch >> VACUUM FULL? > One problem with VACUUM FULL would be autovacuum waiting for an > exclusive lock on the table. Anyway, it is documented now as a possible > issue. I don't care too much about autovacuum waiting awhile to get a lock. I do care about other processes getting queued up behind it, though. Perhaps it would be possible to alter the normal lock queuing semantics for this case, so that autovacuum's request doesn't block later arrivals, and it can only get the lock when no one is interested in the table. Of course, that might never happen, or by the time it does there's no point in VACUUM FULL anymore :-( regards, tom lane