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 B4E9053814 for ; Mon, 18 Apr 2005 10:00:51 -0300 (ADT) 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 80257-10 for ; Mon, 18 Apr 2005 13:00:46 +0000 (GMT) Received: from vms046pub.verizon.net (vms046pub.verizon.net [206.46.252.46]) by svr1.postgresql.org (Postfix) with ESMTP id 2138D536FA for ; Mon, 18 Apr 2005 10:00:39 -0300 (ADT) Received: from jfradkin ([63.162.100.127]) by vms046.mailsrvcs.net (Sun Java System Messaging Server 6.2 HotFix 0.04 (built Dec 24 2004)) with ESMTPA id <0IF500IKM856FCY8@vms046.mailsrvcs.net> for pgsql-performance@postgresql.org; Mon, 18 Apr 2005 08:00:43 -0500 (CDT) Date: Mon, 18 Apr 2005 09:00:48 -0400 From: "Joel Fradkin" Subject: FW: speed of querry? To: "PostgreSQL Perform" Message-id: <000401c54416$a4e57e80$797ba8c0@jfradkin> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Mailer: Microsoft Outlook, Build 10.0.6626 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: quoted-printable Importance: Normal X-Priority: 3 (Normal) X-MSMail-priority: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200504/391 X-Sequence-Number: 11788 What are the statistics for tbljobtitle.id and tbljobtitle.clientnum=20 I added default_statistics_target =3D 250 to the config and re-loaded = the data base. If that is what you mean? --- how many distinct values of each,=20 tbljobtitle.id 6764 for all clients 1018 for SAKS tbljobtitle.clientnum 237 distinct clientnums just 1 for SAKS and are the distributions skewed to a few popular values? There are 3903 distinct values for jobtitle Not sure if I answered the questions, let me know if you need more info. It appears there are 1018 job titles in the table for saks and 6764 for = all the clients. There can be more values as presentation layer can have = more then one value for an id. SAKS is not using presentation layer yet as = there are only 1018 distinct values 1 for each id. Joel