X-Original-To: pgsql-performance@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 95CC2925C48 for ; Thu, 29 May 2003 10:25:42 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 68735-02 for ; Thu, 29 May 2003 10:25:42 -0400 (EDT) Received: from www.pspl.co.in (www.pspl.co.in [202.54.11.65]) by developer.postgresql.org (Postfix) with ESMTP id 62C9F925BCA for ; Thu, 29 May 2003 10:25:40 -0400 (EDT) Received: (from root@localhost) by www.pspl.co.in (8.11.6/8.11.6) id h4TEPex14249 for ; Thu, 29 May 2003 19:55:40 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) by www.pspl.co.in (8.11.6/8.11.0) with ESMTP id h4TEPd614244 for ; Thu, 29 May 2003 19:55:40 +0530 From: "Shridhar Daithankar" To: Date: Thu, 29 May 2003 19:54:43 +0530 MIME-Version: 1.0 Subject: Re: Select query takes long to execute Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3ED66583.20384.551042A@localhost> In-reply-to: <005501c325ea$5879ad10$0200a8c0@WORKSTATION> X-mailer: Pegasus Mail for Windows (v4.11) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/264 X-Sequence-Number: 2043 On 29 May 2003 at 8:58, Kevin Schroeder wrote: > If anyone has any ideas as to why the query is taking so long and what I can > do to make it more efficient I would love to know. Check yor shared buffers setting and effective OS cache setting. If these are appropriately tuned, then it should be fast enough. Is the table vacuumed? Is index taking too much space? Then try reindexing. It might help as vacuum does not reclaim wasted space in index. HTH Bye Shridhar -- Wait! You have not been prepared! -- Mr. Atoz, "Tomorrow is Yesterday", stardate 3113.2