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 B1998D1B42F for ; Wed, 17 Dec 2003 05:30:54 +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 70425-03 for ; Wed, 17 Dec 2003 01:30:24 -0400 (AST) Received: from mallard.mail.pas.earthlink.net (mallard.mail.pas.earthlink.net [207.217.120.48]) by svr1.postgresql.org (Postfix) with ESMTP id 8AF41D1B437 for ; Wed, 17 Dec 2003 01:30:23 -0400 (AST) Received: from hsa158.pool003.at101.earthlink.net ([216.249.70.158] helo=shadovitzcmptr) by mallard.mail.pas.earthlink.net with smtp (Exim 3.33 #1) id 1AWUGN-0004Pg-00 for pgsql-performance@postgresql.org; Tue, 16 Dec 2003 21:30:23 -0800 Received: by localhost with Microsoft MAPI; Tue, 16 Dec 2003 20:45:44 -0800 Message-ID: <01C3C415.93ADBCE0.david@shadovitz.com> From: David Shadovitz Reply-To: "david@shadovitz.com" To: "pgsql-performance@postgresql.org" Subject: Why is restored database faster? Date: Tue, 16 Dec 2003 20:42:58 -0800 X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/248 X-Sequence-Number: 5108 I backed up my database using pg_dump, and then restored it onto a different server using psql. I see that the query "SELECT COUNT(*) FROM myTable" executes immediately on the new server but takes several seconds on the old one. (The servers are identical.) What could account for this difference? Clustering? How can I get the original server to perform as well as the new one? Thanks. -David