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?


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to