From: | Yeb Havinga <yebhavinga(at)gmail(dot)com> |
---|---|
To: | "JOUANIN Nicolas (44)" <nicolas(dot)jouanin(at)dgfip(dot)finances(dot)gouv(dot)fr> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Two different execution plan for the same request |
Date: | 2010-07-07 08:27:05 |
Message-ID: | 4C343A59.7050908@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
JOUANIN Nicolas (44) wrote:
> Hi,
>
> I've trouble with some SQL request which have different execution
> plans when ran on two different servers. One server is the development
> environment, the othe rone is th pre-production env.
> Both servers run postgreSQL 8.3.0 on Linux and :
> - both databases contains the same data (pg_dump/pg_restore between
> servers)
> - instances have the same configuration parameters
> - vaccum and analyze is run every day.
> The only difference I can see is the hardware. The pre-preoduction
> env. has more RAM, more CPU and a RAID5 disk array through LVM where
> data are stored.
Hello Jouanin,
Could you give some more information following the guidelines from
http://wiki.postgresql.org/wiki/SlowQueryQuestions ?
Essential are the contents from both conf files (comments may be removed).
regards,
Yeb Havinga
From | Date | Subject | |
---|---|---|---|
Next Message | JOUANIN Nicolas (44) | 2010-07-07 08:47:45 | Re: Two different execution plan for the same request |
Previous Message | JOUANIN Nicolas (44) | 2010-07-07 07:55:28 | Two different execution plan for the same request |