Re: [PERFORM] Two different execution plan for the same request

2010-07-07 Thread JOUANIN Nicolas (44)
Pour : JOUANIN Nicolas (44) Copie à : Yeb Havinga , pgsql-performance@postgresql.org Date : 07/07/2010 10:59 Hi Nicolas, On Wed, Jul 7, 2010 at 10:47 AM, JOUANIN Nicolas (44) wrote: There were no modification made on the database except a restart yesterday evening and a vacuumdb

Re: [PERFORM] Two different execution plan for the same request

2010-07-07 Thread JOUANIN Nicolas (44)
Nicolas Jouanin Analyste - TVA8ième directive Bureau SI-1C / DAP2 Tel: 02.51.88.50.18 Adoptez l'éco-attitude. N'imprimez ce courriel que si c'est vraimen

[PERFORM] Two different execution plan for the same request

2010-07-07 Thread JOUANIN Nicolas (44)
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/p