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..:-)


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

Reply via email to