Alban Hertroys <haramrae@xxxxxxxxx> writes: > On 13 May 2014 16:48, Vegard Bønes <vegard.bones@xxxxxx> wrote: >> 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. > We can but guess, but... Less guess-worthy answers might be possible if you provide the information suggested here: https://wiki.postgresql.org/wiki/Slow_Query_Questions regards, tom lane