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 D4D0753B09 for ; Thu, 7 Apr 2005 17:33:40 +0100 (BST) 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 30850-09 for ; Thu, 7 Apr 2005 16:33:36 +0000 (GMT) Received: from vms040pub.verizon.net (vms040pub.verizon.net [206.46.252.40]) by svr1.postgresql.org (Postfix) with ESMTP id 1E8E653AAD for ; Thu, 7 Apr 2005 17:33:35 +0100 (BST) Received: from jfradkin ([66.15.127.235]) by vms040.mailsrvcs.net (Sun Java System Messaging Server 6.2 HotFix 0.04 (built Dec 24 2004)) with ESMTPA id <0IEL006IB4NYOHE5@vms040.mailsrvcs.net> for pgsql-performance@postgresql.org; Thu, 07 Apr 2005 11:33:35 -0500 (CDT) Date: Thu, 07 Apr 2005 12:33:46 -0400 From: "Joel Fradkin" Subject: Re: Any way to speed this up? In-reply-to: <3303.1112889874@sss.pgh.pa.us> To: "'Tom Lane'" Cc: "'PostgreSQL Perform'" Message-id: <006701c53b8f$9274fdf0$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=1.397 tagged_above=0 required=5 tests=AWL X-Spam-Level: * X-Archive-Number: 200504/166 X-Sequence-Number: 11563 shared_buffers =3D 8000 # min 16, at least max_connections*2, 8KB each work_mem =3D 8192#1024 # min 64, size in KB max_fsm_pages =3D 30000 # min max_fsm_relations*16, 6 bytes each effective_cache_size =3D 40000 #1000 # typically 8KB each random_page_cost =3D 1.2#4 # units are one sequential page fetch cost These are the items I changed. In the development box I turned random page cost to .2 because I figured = it would all be faster using an index as all my data is at a minimum being selected by clientnum. But the analyze I sent in is from these settings above on a windows box. If I was running the analyze (pgadmin) on a windows box but connecting = to a linux box would the times be accurate or do I have to run the analyze on = the linux box for that to happen? I am a little unclear why I would need an index on associate by location = as I thought it would be using indexes in location and jobtitle for their joins. I did not say where locationid =3D x in my query on the view. I have so much to learn about SQL. Joel