Slow select - Mailing list pgsql-general

I have a table with column of character varying(100). There are about
150.000.000 rows in a table. Index was created as

CREATE INDEX idx_stringv
  ON bn_stringvalue
  USING btree
  (lower(value::text));

I'm trying to execute queries like 'select * from stringvalue where
value=lower(?)'. Making 1000 selects takes about 4-5 min. I did vacuum and
analyze on this table and checked that query plan uses index. What can I do
to make it faster?

Thanks in advance, Yulia
--
View this message in context: http://old.nabble.com/Slow-select-tp26810673p26810673.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.