On Mon, Apr 29, 2002 at 07:09:47PM +0200, Uros Gruber wrote:
> then i do some other queries and vacuum and when i try again
> SAME explain it prints that it was used Seq Scan
>
> It this normal or what. Or is some kind of a bug.
PostgreSQL attempt to adjust it's plan depending on what data is in the
table. If by adding new data the distribution has changed, it's decided it's
now better to do this other plan.
Is this other plan significantly slower?
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Canada, Mexico, and Australia form the Axis of Nations That
> Are Actually Quite Nice But Secretly Have Nasty Thoughts About America
