X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1CDA2D1C4ED for ; Wed, 17 Dec 2003 06:31:48 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 71054-09 for ; Wed, 17 Dec 2003 02:31:17 -0400 (AST) Received: from smtp.pspl.co.in (unknown [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id DE46ED1C4D0 for ; Wed, 17 Dec 2003 02:31:13 -0400 (AST) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id hBH6VIbo014665 for ; Wed, 17 Dec 2003 12:01:18 +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 hBH6VDQK014554; Wed, 17 Dec 2003 12:01:13 +0530 Message-ID: <3FDFF82A.2070201@persistent.co.in> Date: Wed, 17 Dec 2003 12:01:06 +0530 From: Shridhar Daithankar Organization: Persistent Systems Pvt. Ltd. User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Neil Conway Cc: "david@shadovitz.com" , "pgsql-performance@postgresql.org" Subject: Re: Why is restored database faster? References: <01C3C415.93ADBCE0.david@shadovitz.com> <87iskgugpe.fsf@mailbox.samurai.com> In-Reply-To: <87iskgugpe.fsf@mailbox.samurai.com> 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: 200312/251 X-Sequence-Number: 5111 Neil Conway wrote: >>How can I get the original server to perform as well as the new one? Well, you have the answer. Dump the database, stop postmaster and restore it. That should be faster than original one. > > (BTW, "SELECT count(*) FROM table" isn't a particularly good DBMS > performance indication...) Particularly in case of postgresql..:-) Shridhar