Re: [PERFORM] Not same plan between static and prepared query

2013-06-10 Thread Ghislain ROUVIGNAC
Hello Amit, Thank you for your help. You are right, it work fine with PostgreSQL 9.2. *Ghislain ROUVIGNAC* 2013/6/6 Amit Kapila > > On Thursday, June 06, 2013 1:56 PM Ghislain ROUVIGNAC wrote: > > Hello, > > > > We have a strange issue related to a prepared st

[PERFORM] Not same plan between static and prepared query

2013-06-06 Thread Ghislain ROUVIGNAC
y coalescedate(lignecomma0_2_.dateCreationSysteme) desc limit $1; explain analyze execute query(500); We met the same behaviour with both : - PostgreSQL 8.4.8 on Windows 2008 (Prod) - PostgreSQL 8.4.8 and 8.4.17 on Windows 7 (Dev) I hope someone has any idea. *Ghislain ROUVIGNAC*

Re: [PERFORM] Slow queries after vacuum analyze

2012-12-27 Thread Ghislain ROUVIGNAC
e with a customer where we had to increase the statistics parameter for a primary key. So I'd like to know if there is a way to identify for which column we have to change the statistics. *Ghislain ROUVIGNAC* 2012/12/18 Kevin Grittner > Ghislain ROUVIGNAC wrote: > > > Memory :

[PERFORM] Slow queries after vacuum analyze

2012-12-13 Thread Ghislain ROUVIGNAC
appreciated. Cordialement, *Ghislain ROUVIGNAC* Ingénieur R&D g...@sylob.com 7 rue Marcel Dassault - Z.A. La Mouline - 81990 Cambon d'Albi - FRANCE Tel : 05 63 53 08 18 - Fax : 05 63 53 07 42 - www.sylob.com Support : 05 63 53 78 35 - supp...@sylob.com Entreprise certifiée ISO 9001 version