Skip site navigation (1) Skip section navigation (2)

Why is restored database faster?

From: David Shadovitz <david(at)shadovitz(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Why is restored database faster?
Date: 2003-12-17 04:42:58
Message-ID: 01C3C415.93ADBCE0.david@shadovitz.com (view raw or flat)
Thread:
Lists: pgsql-performance
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

Responses

pgsql-performance by date

Next:From: Neil ConwayDate: 2003-12-17 06:00:13
Subject: Re: Why is restored database faster?
Previous:From: David ShadovitzDate: 2003-12-17 04:37:02
Subject: Re: Why is VACUUM ANALYZE <table> so slow?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group