On Sep 5, 2007, at 18:57 , Liam Slusser wrote:
I've been trying to replicate a database but each time I
replication it the
performance of the copy is about 100 times slower (~100ms to ~8
seconds for
the same query). The only way I have found to replicate it and
keep the
same performance is doing a hotcopy of the database.
<snip>
Is the hardware identical? Is your postgres.conf tuned identically?
Cheers,
M
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
