X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 708E5DA206 for ; Fri, 11 Nov 2005 16:48:18 -0400 (AST) 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 44287-08 for ; Fri, 11 Nov 2005 20:48:16 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mtiwmhc12.worldnet.att.net (mtiwmhc12.worldnet.att.net [204.127.131.116]) by svr1.postgresql.org (Postfix) with ESMTP id 09315DA049 for ; Fri, 11 Nov 2005 16:48:16 -0400 (AST) Received: from [10.10.100.50] (unknown[216.113.237.29]) by worldnet.att.net (mtiwmhc12) with ESMTP id <2005111120481511200f4vq8e>; Fri, 11 Nov 2005 20:48:16 +0000 Message-ID: <43750390.3090707@att.net> Date: Fri, 11 Nov 2005 15:48:16 -0500 From: DW Reply-To: dwinner-lists@att.net User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: slow queries after ANALYZE References: <4374EDF1.5010709@att.net> <21006.1131737530@sss.pgh.pa.us> In-Reply-To: <21006.1131737530@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.047 required=5 tests=[AWL=0.047] X-Spam-Score: 0.047 X-Spam-Level: X-Archive-Number: 200511/215 X-Sequence-Number: 15472 Tom Lane wrote: > It would be interesting to see EXPLAIN ANALYZE results in both cases, > plus the contents of the relevant pg_stats rows. (BTW, you need not > dump and reload to get back to the virgin state --- just delete the > relevant rows from pg_statistic.) Also we'd want to know exactly what > PG version this is, and on what sort of platform. > Thanks for replying. I've got a message into to my team asking if I need to de-identify some of the table names before I go submitting output to a public mailing list. In the meantime, again I'm new to this -- I got pg_stats; which rows are the relevent ones? Also, I am running postgresql-server-7.4.9 from FreeBSD port (with optimized CFLAGS turned on during compiling) OS: FreeBSD 5.4 p8 Thanks, DW