X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 3620A9DC87D for ; Fri, 20 Jan 2006 13:29:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13159-09 for ; Fri, 20 Jan 2006 13:29:11 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by postgresql.org (Postfix) with ESMTP id B28099DC80D for ; Fri, 20 Jan 2006 13:29:09 -0400 (AST) Received: from [192.168.1.100] (or-67-76-146-141.sta.sprint-hsd.net [67.76.146.141]) (authenticated bits=0) by hosting.commandprompt.com (8.13.4/8.13.4) with ESMTP id k0KHJI9Z032567; Fri, 20 Jan 2006 09:19:22 -0800 Message-ID: <43D11E62.1080206@commandprompt.com> Date: Fri, 20 Jan 2006 09:31:14 -0800 From: "Joshua D. Drake" User-Agent: Thunderbird 1.5 (X11/20051201) MIME-Version: 1.0 To: "Jim C. Nasby" CC: Mark Kirkwood , Michael Crozier , pgsql-performance@postgresql.org Subject: Re: Autovacuum / full vacuum (off-topic?) References: <034701c61c46$f427df20$f20214ac@bite.lt> <60d5ipcw8y.fsf@dba2.int.libertyrms.com> <200601181115.51850.crozierm@conducivetech.com> <20060118225257.GY17896@pervasive.com> <43D01C68.3030204@paradise.net.nz> <20060120171214.GE20182@pervasive.com> In-Reply-To: <20060120171214.GE20182@pervasive.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (hosting.commandprompt.com [192.168.1.101]); Fri, 20 Jan 2006 09:19:23 -0800 (PST) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.068 required=5 tests=[AWL=0.068] X-Spam-Score: 0.068 X-Spam-Level: X-Archive-Number: 200601/345 X-Sequence-Number: 16823 Jim C. Nasby wrote: > BTW, given all the recent discussion about vacuuming and our MVCC, > http://www.pervasive-postgres.com/lp/newsletters/2006/Insights_Postgres_Jan.asp#3 > should prove interesting. :) > Please explain... what is the .asp extension. I have yet to see it reliable in production ;) -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: PLphp, PLperl - http://www.commandprompt.com/