X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 236873A3B6B; Wed, 3 Nov 2004 22:36:50 +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 20695-07; Wed, 3 Nov 2004 22:36:38 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 69F183A1D8A; Wed, 3 Nov 2004 22:36:40 +0000 (GMT) Received: from [192.168.1.51] (dsl093-038-087.pdx1.dsl.speakeasy.net [66.93.38.87]) (authenticated) by hosting.commandprompt.com (8.11.6/8.11.6) with ESMTP id iA3Madm11845; Wed, 3 Nov 2004 14:36:39 -0800 Message-ID: <41895D72.2060305@commandprompt.com> Date: Wed, 03 Nov 2004 14:36:34 -0800 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla Thunderbird 0.8 (X11/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Justin Clift Cc: "Marc G. Fournier" , pgsql-www@postgresql.org Subject: Re: pg_autovacuum is nice ... but ... References: <20041103155855.O82047@ganymede.hub.org> <41895BDA.1090903@postgresql.org> In-Reply-To: <41895BDA.1090903@postgresql.org> Content-Type: multipart/mixed; boundary="------------000407000007080505000100" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/63 X-Sequence-Number: 5794 This is a multi-part message in MIME format. --------------000407000007080505000100 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Justin Clift wrote: > Marc G. Fournier wrote: > > >> Do a vacuum full analyze on the two databases being called, and load >> time went from 2.4sec to .46sec: > > > Hmmmm, is there any chance your Free Space Map settings aren't high enough? > I could be wrong but my understanding is that pg_autovacuum won't vacuum system tables so eventually you still need to perform a full vacuum (not neccessarily a vacuum full). Could this be the issue? > Regards and best wishes, > > Justin Clift > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match -- Command Prompt, Inc., home of PostgreSQL Replication, and plPHP. Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL --------------000407000007080505000100 Content-Type: text/x-vcard; charset=utf-8; name="jd.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jd.vcf" begin:vcard fn:Joshua D. Drake n:Drake;Joshua D. org:Command Prompt, Inc. adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl. x-mozilla-html:FALSE url:http://www.commandprompt.com/ version:2.1 end:vcard --------------000407000007080505000100--