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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-performance@xxxxxxxxxxxxxx
Subject: Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1
From: Jeremy <jgh@xxxxxxxxxxx>
Date: Sun, 13 Mar 2011 12:21:47 +0000

The row estimate is way off.  Is autovacuum disabled?
-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Prev by Date: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1
Next by Date: Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1
Previous by thread: Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1
Next by thread: Re: Performance regression from 8.3.7 to 9.0.3
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux