X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 7E9EC9DD5E5 for ; Sat, 25 Feb 2006 09:22:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79718-01 for ; Sat, 25 Feb 2006 09:22:58 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web35802.mail.mud.yahoo.com (web35802.mail.mud.yahoo.com [66.163.179.171]) by postgresql.org (Postfix) with SMTP id 8FACB9DD528 for ; Sat, 25 Feb 2006 09:22:29 -0400 (AST) Received: (qmail 74102 invoked by uid 60001); 25 Feb 2006 13:22:31 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=Uh6wQ60NmIb6ItGwpX3KjcFpHVK/mt1LOfzntAWgT2pBzf4P18DDezumvZ2BNCVGgalde2ciBbh4if9+o1MvOeIhOI/DJbCcIWoZ3j9B+afB3bqXo3soRxGSP383V6nZIW95+G89UUeRgTu8/We+IVqfWD6DATOVQD5+bhNYjSo= ; Message-ID: <20060225132231.74100.qmail@web35802.mail.mud.yahoo.com> Received: from [220.133.0.77] by web35802.mail.mud.yahoo.com via HTTP; Sat, 25 Feb 2006 21:22:31 CST Date: Sat, 25 Feb 2006 21:22:31 +0800 (CST) From: Vincent Chen Subject: PostgreSQL performance tuning To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=big5 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.358 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879] X-Spam-Score: 1.358 X-Spam-Level: * X-Archive-Number: 200602/334 X-Sequence-Number: 20755 Hi, all I have a postgresql 7.4 running on mandriva linux 10.1 with 512M RAM & AMD 2000+ CPU. I increased system share memory to 128M, buffer to 64M, sort memory to 32M. A single query do finish much faster. Now I need to analyze some weekly data involving hundred queries with 'group by order by' operation. Total data less than 250M, but did take some time to complete. How can I tune my system to handle a lot of concurrent quries at the same time and do it faster? BTW, upgrade hardware is not an option at this time. ;> Thanks, Vincent Chen ___________________________________________________ 最新版 Yahoo!奇摩即時通訊 7.0,免費網路電話任你打! http://messenger.yahoo.com.tw/