Re: [PERFORM] Postgres does not utilize indexes. Why?

[Michal Taborsky]

Artimenko Igor wrote:
  id int8 NOT NULL DEFAULT nextval('next_id_seq'::text) INIQUE,
ID column is bigint, but '50000' is int, therefore the index does not 
match. You need to cast your clause like this:

select id from test where id = 50000::int8

Advertising







Also, issue VACUUM ANALYZE, so Postgres knows about the structure of the 
data.

--
Michal Taborsky
http://www.taborsky.cz
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])