X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 79D5A475B99 for ; Sat, 3 May 2003 14:31:57 -0400 (EDT) Received: from joeconway.com (66-146-172-86.skyriver.net [66.146.172.86]) by postgresql.org (Postfix) with ESMTP id ACFDC475A8D for ; Sat, 3 May 2003 14:31:36 -0400 (EDT) Received: from [192.168.5.3] (account jconway HELO joeconway.com) by joeconway.com (CommuniGate Pro SMTP 4.0.4) with ESMTP-TLS id 1727818; Sat, 03 May 2003 12:07:09 -0700 Message-ID: <3EB40AE4.8080007@joeconway.com> Date: Sat, 03 May 2003 11:31:00 -0700 From: Joe Conway User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.3) Gecko/20030312 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Becky Neville Cc: pgsql-performance@postgresql.org Subject: Re: why is the db so slow? References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-34.3 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,NO_DNS_FOR_FROM, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_MOZILLA_UA autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/25 X-Sequence-Number: 1804 Becky Neville wrote: > Are there any parameters I can set to speed things up? > You haven't given us much in the way of specifics to work with, but here is a short list of things to try/do: - read (amongst other things): http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/performance-tips.html http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/runtime-config.html - run "VACUUM ANALYZE" on your database - adjust key default configuration settings: shared_buffers = 1000 (or maybe 2000 or even 4000 -- above that you'd need root access, and it might not help anyway) sort_mem = 8192 (depending on the amount of RAM in the server, this might be too high/low, but start with something in the 4000 to 8000K range) - run "EXPLAIN ANALYZE" on your queries, and send in the results and the table structure details to the list. HTH, Joe