Re: [GENERAL] 9.1 vs 8.4 performance

2012-09-24 Thread salah jubeh
To: Scott Marlowe scott.marl...@gmail.com; salah jubeh s_ju...@yahoo.com Cc: pgsql pgsql-general@postgresql.org Sent: Friday, September 21, 2012 9:40 PM Subject: Re: [GENERAL] 9.1 vs 8.4 performance One thing I sometimes forget to do after loading up an empty DB with data is to run analyze.  I usually

Re: [GENERAL] 9.1 vs 8.4 performance

2012-09-24 Thread Merlin Moncure
From: Gauthier, Dave dave.gauth...@intel.com To: Scott Marlowe scott.marl...@gmail.com; salah jubeh s_ju...@yahoo.com Cc: pgsql pgsql-general@postgresql.org Sent: Friday, September 21, 2012 9:40 PM Subject: Re: [GENERAL] 9.1 vs 8.4 performance One thing I sometimes forget

Re: [GENERAL] 9.1 vs 8.4 performance

2012-09-22 Thread Craig Ringer
On 09/21/2012 10:32 PM, salah jubeh wrote: I am running queries sequentially on each machine using a database dumped from a life server , and 9.1 server is much slower than 8.4. https://wiki.postgresql.org/wiki/Slow_Query_Questions More detail needed. -- Craig Ringer -- Sent via

[GENERAL] 9.1 vs 8.4 performance

2012-09-21 Thread salah jubeh
Hello, I have two postgresql servers 9.1.5 and 8.4.8  running on ubuntu machine, both are fresh installs and both has the same configuration files and databases. I am running queries sequentially on each machine using a database  dumped from a life server ,  and 9.1 server is much slower than

Re: [GENERAL] 9.1 vs 8.4 performance

2012-09-21 Thread Jeff Janes
On Fri, Sep 21, 2012 at 7:32 AM, salah jubeh s_ju...@yahoo.com wrote: Hello, I have two postgresql servers 9.1.5 and 8.4.8 running on ubuntu machine, both are fresh installs and both has the same configuration files and databases. I am running queries sequentially on each machine using a

Re: [GENERAL] 9.1 vs 8.4 performance

2012-09-21 Thread Scott Marlowe
On Fri, Sep 21, 2012 at 8:32 AM, salah jubeh s_ju...@yahoo.com wrote: Hello, I have two postgresql servers 9.1.5 and 8.4.8 running on ubuntu machine, both are fresh installs and both has the same configuration files and databases. I am running queries sequentially on each machine using a

Re: [GENERAL] 9.1 vs 8.4 performance

2012-09-21 Thread Gauthier, Dave
jubeh Cc: pgsql Subject: Re: [GENERAL] 9.1 vs 8.4 performance On Fri, Sep 21, 2012 at 8:32 AM, salah jubeh s_ju...@yahoo.com wrote: Hello, I have two postgresql servers 9.1.5 and 8.4.8 running on ubuntu machine, both are fresh installs and both has the same configuration files

Re: [GENERAL] 9.1 vs 8.4 performance

2012-09-21 Thread Gauthier, Dave
] On Behalf Of Scott Marlowe Sent: Friday, September 21, 2012 3:01 PM To: salah jubeh Cc: pgsql Subject: Re: [GENERAL] 9.1 vs 8.4 performance On Fri, Sep 21, 2012 at 8:32 AM, salah jubeh s_ju...@yahoo.com wrote: Hello, I have two postgresql servers 9.1.5 and 8.4.8 running on ubuntu machine, both