On Mon, Jul 8, 2013 at 9:21 AM, Tom Harkaway wrote:
> The ‘explain’ output for the query is very different between the two
> systems.
>
You ran ANALYZE after loading the data? Can you post the query and EXPLAIN
ANALYZE output?
Also, some tips on getting answers with (potentially) less ping pon
I am migrating a Postgres 8.4 installation on a dedicated server to Postgres
9.2 running on a Virtual Machine. A sample query that run in 10 minutes on the
8.4 installation take 40 minutes on the 9.2 installation.
Current Server, Postgres 8.4
* 6-core, 3GHz AMD system
* 12GB of
