Home > mailing lists

Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1 - Mailing list pgsql-performance

From	Jeremy
Subject	Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1
Date	March 13, 2011 12:41:33
Msg-id	md3w5nxingva4unk8ifr5ufw.1300018907334@email.android.com Whole thread Raw
List	pgsql-performance

Tree view

The row estimate is way off.  Is autovacuum disabled?

pgsql-performance by date:

From: "John Surcombe"
Date: 13 March 2011, 10:31:48
Subject: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1

From: Tom Lane
Date: 13 March 2011, 16:24:59
Subject: Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1

Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1 - Mailing list pgsql-performance

Previous

Next