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
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
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
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
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
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
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
] 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