[PERFORM] Almost infinite query -> Different Query Plan when changing where clause value

Some informations: The following problem has been detected on Postgresql 8.3 and 8.4. on System linux or windows Default AutoVacuum daemon working One pg_dump every day This happens sometimes and i don't see what can be the cause. A manual Vacuum Analyse repair that problem. Dear you all,

Re: [PERFORM] Almost infinite query -> Different Query Plan when changing where clause value

Thanks kevin for your answer. Here is some additionnal informations attached as files. regards. Lionel Kevin Grittner a écrit : lionel duboeuf wrote: Some informations: The following problem has been detected on Postgresql 8.3 and 8.4. on System linux or windows Default

Re: [PERFORM] Almost infinite query -> Different Query Plan when changing where clause value

See as attachment the "correct" query plan for an other 'user'. I confirm by executing manual "VACUUM ANALYZE" that the problem is solved. But what i don't understand is that i would expect autovacuum to do the job. Lionel Kevin Grittner a écrit : lionel d

Re: [PERFORM] Almost infinite query -> Different Query Plan when changing where clause value

ry problem ? If so, what would you suggest me to do to avoid the problem again ?. Thanks Lionel Kevin Grittner a écrit : lionel duboeuf wrote: Kevin Grittner a écrit : I just reread your original email, and I'm not sure I understand what you meant regarding VACUUM ANAL

Re: [PERFORM] Almost infinite query -> Different Query Plan when changing where clause value

ry problem ? If so, what would you suggest me to do to avoid the problem again ?. Thanks Lionel Kevin Grittner a écrit : lionel duboeuf wrote: Kevin Grittner a écrit : I just reread your original email, and I'm not sure I understand what you meant regarding VACUUM ANAL

Re: [PERFORM] Almost infinite query -> Different Query Plan when changing where clause value

Thank you Kevin and Scott for all the explanations. ;-) regards Lionel -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] Almost infinite query -> Different Query Plan when changing where clause value

lionel duboeuf a écrit : Thank you Kevin and Scott for all the explanations. ;-) regards Lionel Sorry for forgetting Jorge also. regards. All this ,encourage me to know more about database management. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make