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 313575288B for ; Tue, 21 Jun 2005 19:23:13 -0300 (ADT) 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 29731-01 for ; Tue, 21 Jun 2005 22:23:02 +0000 (GMT) Received: from cassarossa.samfundet.no (cassarossa.samfundet.no [129.241.93.19]) by svr1.postgresql.org (Postfix) with ESMTP id D9CEE528D5 for ; Tue, 21 Jun 2005 19:23:00 -0300 (ADT) Received: from trofast.ipv6.sesse.net ([2001:700:300:dc03:20e:cff:fe36:a766] helo=trofast.sesse.net) by cassarossa.samfundet.no with esmtp (Exim 4.50) id 1Dkr92-0000nA-OJ for pgsql-performance@postgresql.org; Wed, 22 Jun 2005 00:23:02 +0200 Received: from sesse by trofast.sesse.net with local (Exim 3.36 #1 (Debian)) id 1Dkr92-0004sB-00 for ; Wed, 22 Jun 2005 00:23:00 +0200 Date: Wed, 22 Jun 2005 00:23:00 +0200 From: "Steinar H. Gunderson" To: pgsql-performance@postgresql.org Subject: Re: autovacuum suggestions for 500,000,000+ row tables? Message-ID: <20050621222300.GA18626@uio.no> Mail-Followup-To: pgsql-performance@postgresql.org References: <200506201046.42062.josh@agliodbs.com> <7E161634-29A0-4DBC-A303-3675D705A965@advfn.com> <200506211013.40993.josh@agliodbs.com> <20023F5A-4C74-41C8-8F46-0E16A45872AF@advfn.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <20023F5A-4C74-41C8-8F46-0E16A45872AF@advfn.com> X-Operating-System: Linux 2.6.11.8 on a i686 X-Message-Flag: Outlook? --> http://www.mozilla.org/products/thunderbird/ User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.019 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/417 X-Sequence-Number: 13054 On Tue, Jun 21, 2005 at 11:08:43PM +0100, Alex Stapleton wrote: > Bloody Debian stable. I might have to experiment with building from > source or using alien on debian to convert the rpms. Fun. Oh well. Or just pull in postgresql-8.0 from unstable; sid is close enough to sarge for it to work quite well in practice, AFAIK. You'll lose the security support, though, but you will with building from source or using alien anyhow :-) /* Steinar */ -- Homepage: http://www.sesse.net/