X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id D50EBD1B506 for ; Wed, 1 Oct 2003 07:04:20 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 62766-08 for ; Wed, 1 Oct 2003 04:03:33 -0300 (ADT) Received: from smtp.pspl.co.in (unknown [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id 83F2DD1B53C for ; Wed, 1 Oct 2003 04:03:30 -0300 (ADT) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id h9176Eu5004435 for ; Wed, 1 Oct 2003 12:36:14 +0530 Received: from persistent.co.in (daithan.intranet.pspl.co.in [192.168.7.161]) (authenticated bits=0) by persistent.co.in (8.12.9/8.12.9) with ESMTP id h9176D1r004409; Wed, 1 Oct 2003 12:36:13 +0530 Message-ID: <3F7A7CBA.4060507@persistent.co.in> Date: Wed, 01 Oct 2003 12:35:30 +0530 From: Shridhar Daithankar Organization: Persistent Systems Pvt. Ltd. User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5b) Gecko/20030917 Thunderbird/0.3a X-Accept-Language: en-us, en MIME-Version: 1.0 To: David Griffiths Cc: pgsql-performance@postgresql.org Subject: Re: Tuning/performance issue.... References: <058d01c38791$0d0a91b0$6501a8c0@griffiths2> In-Reply-To: <058d01c38791$0d0a91b0$6501a8c0@griffiths2> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/7 X-Sequence-Number: 3755 David Griffiths wrote: > And finally, > > Here's the contents of the postgresql.conf file (I've been playing with > these setting the last couple of days, and using the guide @ > http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html to > make sure I didn't have it mis-tuned): > > tcpip_socket = true > max_connections = 500 # We will need quite a few connections; > currently only one connection to database, however > port = 5432 > shared_buffers = 5000 # I've tried 5000 to 80,000 with no > apparent difference > wal_buffers = 16 > sort_mem = 256 # decreased this due to the large # of > connectiosn > effective_cache_size = 50000 # read that this can improve performance; > hasn't done anything. Reading this whole thread, I think most of the improvement you would get would be from rethinking your schema from PG point of view and examine each query. After you changed your last query as Tom suggested for explicit join, how much improvement did it make? I noticed that you put 'commercial_entity.commercial_entity_id=225528' as a second codition. Does it make any difference to put it ahead in where clause list? HTH Shridhar