[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] I don't understand this
From:       Martijn van Oosterhout <kleptog () svana ! org>
Date:       2002-04-29 23:36:55
[Download RAW message or body]

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html
[prev in list] [next in list] [prev in thread] [next in thread]