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 A1FA13A3F07 for ; Sat, 6 Nov 2004 04:07:05 +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 56698-07 for ; Sat, 6 Nov 2004 04:06:57 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 9AECE3A3E86 for ; Sat, 6 Nov 2004 04:06:56 +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 iA646pU3025528; Fri, 5 Nov 2004 23:06:52 -0500 (EST) To: patrick ~ Cc: pgsql-performance@postgresql.org Subject: Re: vacuum analyze slows sql query In-reply-to: <20041106002649.19809.qmail@web52107.mail.yahoo.com> References: <20041106002649.19809.qmail@web52107.mail.yahoo.com> Comments: In-reply-to patrick ~ message dated "Fri, 05 Nov 2004 16:26:49 -0800" Date: Fri, 05 Nov 2004 23:06:51 -0500 Message-ID: <25527.1099714011@sss.pgh.pa.us> From: Tom Lane 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/121 X-Sequence-Number: 9075 patrick ~ writes: > 1. Is this really the only solution left for me? You still haven't followed the suggestions that were given to you (ie, find out what is happening with the plan for the query inside the problematic function). regards, tom lane