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