Rauan Maemirov wrote: > EXPLAIN SELECT [...] Please show us the results of EXPLAIN ANALYZE SELECT ... Also, please show us the table layout (including indexes), and details about your hardware and PostgreSQL configuration. See this page for details: http://wiki.postgresql.org/wiki/SlowQueryQuestions > As you can see the query doesn't use index. That means that either the optimizer thinks that the index isn't usable for this query (due to type mismatch or some such) or that it thinks a plan without the index costs less to run (i.e., it will generally run faster). You haven't told us enough to know whether that is actually true, much less how to allow PostgreSQL to develop more accurate costing estimates in your environment if it's currently wrong about this. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
