On 05/13/2014 08:48 AM, Vegard Bønes wrote:
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 than hardware issues, but in theory, the test servers (there are more than one, with the same performance problems) should be better than my laptop in all ways. Have I missed something obvious?
regards,
Vegard
First suspicion is of course a lack of indexing on the original. I would compare the full definitions of the tables involved.