Why is restored database faster? - Mailing list pgsql-performance

From David Shadovitz
Subject Why is restored database faster?
Date
Msg-id 01C3C415.93ADBCE0.david@shadovitz.com
Whole thread Raw
Responses Re: Why is restored database faster?
Re: Why is restored database faster?
List 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

pgsql-performance by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Nested loop performance
Next
From: David Shadovitz
Date:
Subject: Re: Why is VACUUM ANALYZE so slow?