Maxim Boguk <mbo...@masterhost.ru> writes: > Somehow postgres think index scan on singlecolumn index slower comparing to > scan on 4th field of 4column index.
It does know better than that. I'm wondering if the single-column index has become very bloated or something. Have you compared the physical index sizes? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general