X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1E662D1E5EE for ; Fri, 30 Apr 2004 01:30:48 -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 21470-07 for ; Fri, 30 Apr 2004 01:30:28 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 2B52ED1DC9D for ; Fri, 30 Apr 2004 01:30:27 -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 i3U4URcg020620; Fri, 30 Apr 2004 00:30:27 -0400 (EDT) To: Joseph Shraibman Cc: pgsql-performance@postgresql.org Subject: Re: Insert only tables and vacuum performance In-reply-to: References: Comments: In-reply-to Joseph Shraibman message dated "Thu, 29 Apr 2004 19:08:23 -0400" Date: Fri, 30 Apr 2004 00:30:26 -0400 Message-ID: <20619.1083299426@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/519 X-Sequence-Number: 6819 Joseph Shraibman writes: > I have a table that is never updated, only INSERTED into. Is there a way > I can prevent vacuum wasting time on this table What makes you think vacuum is wasting much time on this table? AFAICS it will only update any unfixed hint bits ... regards, tom lane