| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Uros Gruber <uros(at)sir-mag(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: I don't understand this |
| Date: | 2002-04-29 23:36:55 |
| Message-ID: | 20020430093654.A16960@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)svana(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roberto Andrade Fonseca | 2002-04-30 02:39:00 | Bookbiz database |
| Previous Message | Scott Marlowe | 2002-04-29 23:03:11 | Re: percent function in table? |