I don't understand this - Mailing list pgsql-general

From Uros Gruber
Subject I don't understand this
Date
Msg-id 1168410549.20020429190947@sir-mag.com
Whole thread Raw
Responses Re: I don't understand this  (Martijn van Oosterhout <kleptog@svana.org>)
Re: I don't understand this  (Jan Wieck <janwieck@yahoo.com>)
List pgsql-general
Hi!

i create some table with primary key and one index key
Then i insert data and try some explain on my select.

it tells me that index was used.


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.


--
tia,
 Uros                          mailto:uros.gruber@sir-mag.com


pgsql-general by date:

Previous
From: tony
Date:
Subject: Re: pid gets overwritten in OSX
Next
From: Tom Jenkins
Date:
Subject: Re: What popular, large commercial websites run