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.
Please note I didn'
I don't know how I could have missed that - that sure enough that did the
trick! Thanks to all that answered! :)
liam
On 9/5/07 4:34 PM, "Chris" <[EMAIL PROTECTED]> wrote:
You need to analyze, not vacuum full. pg_dump doesn't include any
analyze statements, you need to do that manually.
--
