Maxim Boguk <mboguk@xxxxxxxxxxxxx> writes: > Tom Lane wrote: >> 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? > Table fresh loaded from dump on test server... So no index bloat for sure... > As for comparing physical sizes, right single column index indeed smaller then wrong one: Huh. I get sane-looking choices when I try a similar case here. Can you put together a self-contained test case? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
