| From: | Vegard Bønes <vegard(dot)bones(at)met(dot)no> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | better performance on poorer machine? |
| Date: | 2014-05-13 14:48:16 |
| Message-ID: | 49921184.183089.1399992496368.JavaMail.root@imap1b |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yeb Havinga | 2014-05-13 15:20:12 | Re: Natural key woe |
| Previous Message | Adrian Klaver | 2014-05-13 13:41:50 | Re: Question about synchronous replication |