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 A1197D1B4E5 for ; Mon, 8 Sep 2003 14:49:05 +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 57679-05 for ; Mon, 8 Sep 2003 11:48:37 -0300 (ADT) Received: from smtp.pspl.co.in (unknown [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id E66EFD1B4ED for ; Mon, 8 Sep 2003 11:48:31 -0300 (ADT) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id h88EuHNe020987 for ; Mon, 8 Sep 2003 20:26:17 +0530 Received: from daithan (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 h88EuEsv020959 for ; Mon, 8 Sep 2003 20:26:15 +0530 From: "Shridhar Daithankar" To: pgsql-performance@postgresql.org Date: Mon, 08 Sep 2003 20:20:35 +0530 MIME-Version: 1.0 Subject: Re: Serious issues with CPU usage Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3F5CE493.6485.15FEE75A@localhost> In-reply-to: <200309081731.13136.andris@estpak.ee> References: <9957.1063029873@sss.pgh.pa.us> X-mailer: Pegasus Mail for Windows (v4.12a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/123 X-Sequence-Number: 3489 On 8 Sep 2003 at 17:31, Andri Saar wrote: > Note to future generations: default postgres configuration settings are very > conservative and don't be afraid to VACUUM very often. You should have looked at earlier default postgresql they were arcane by that standard. 7.4 at least attempts to determine the shared_buffers while doing initdb. That results in much better default performance. Bye Shridhar -- Ritchie's Rule: (1) Everything has some value -- if you use the right currency. (2) Paint splashes last longer than the paint job. (3) Search and ye shall find -- but make sure it was lost.