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.