Re: [GENERAL] better performance on poorer machine?

2014-05-14 Thread Vegard Bønes
time! VG - Original Message - Fra: "Alban Hertroys" Til: "Vegard Bønes" Kopi: pgsql-general@postgresql.org Sendt: 13. mai 2014 17:49:28 Emne: Re: [GENERAL] better performance on poorer machine? On 13 May 2014 16:48, Vegard Bønes wrote: > I have a databas

Re: [GENERAL] better performance on poorer machine?

2014-05-13 Thread Tom Lane
Alban Hertroys writes: > On 13 May 2014 16:48, Vegard Bønes 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 >>

Re: [GENERAL] better performance on poorer machine?

2014-05-13 Thread Alban Hertroys
On 13 May 2014 16:48, Vegard Bønes 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...

Re: [GENERAL] better performance on poorer machine?

2014-05-13 Thread Rob Sargent
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 th

[GENERAL] better performance on poorer machine?

2014-05-13 Thread Vegard Bønes
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 ev