Hi,
I have a database on a test server with queries that perform terribly. Trying to fix this problem, I copied the
database(using pg_dump) to my laptop, and reran tests there. The same queries perform perfectly on my laptop.
I have tried to use the same postgresql.conf, and run ANALYZE and even VACUUM ANALYZE on the databases, but the problem
remains.
EXPLAIN shows a somewhat different query plan for each database.
Now I have no idea what to do next. How can I go about trying to find the cause of this? I can see no other explanation
thanhardware issues, but in theory, the test servers (there are more than one, with the same performance problems)
shouldbe better than my laptop in all ways. Have I missed something obvious?
regards,
Vegard