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 9E55CD9CF0 for ; Fri, 11 Nov 2005 17:25:52 -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 63379-03 for ; Fri, 11 Nov 2005 21:25:50 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 2021DD9CEC for ; Fri, 11 Nov 2005 17:25:50 -0400 (AST) 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 jABLPqrb021670; Fri, 11 Nov 2005 16:25:52 -0500 (EST) To: dwinner-lists@att.net cc: pgsql-performance@postgresql.org Subject: Re: slow queries after ANALYZE In-reply-to: <43750390.3090707@att.net> References: <4374EDF1.5010709@att.net> <21006.1131737530@sss.pgh.pa.us> <43750390.3090707@att.net> Comments: In-reply-to DW message dated "Fri, 11 Nov 2005 15:48:16 -0500" Date: Fri, 11 Nov 2005 16:25:52 -0500 Message-ID: <21669.1131744352@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.006 required=5 tests=[AWL=0.006] X-Spam-Score: 0.006 X-Spam-Level: X-Archive-Number: 200511/216 X-Sequence-Number: 15473 DW writes: > In the meantime, again I'm new to this -- I got pg_stats; which rows are > the relevent ones? The ones for columns that are mentioned in the problem query. I don't think you need to worry about columns used only in the SELECT output list, but anything used in WHERE, GROUP BY, etc is interesting. > Also, I am running postgresql-server-7.4.9 from FreeBSD port (with > optimized CFLAGS turned on during compiling) > OS: FreeBSD 5.4 p8 The hardware environment (particularly disks/filesystems) is relevant too. regards, tom lane