Re: Slow queries when ORDER BY ... DESC with table inheritance (no index scan backwards) - Mailing list pgsql-general

"DANG Trieu" <tdang@miranda.com> writes:
> On the "abstract" table (event):
> gsmlog3_30=# explain analyze select * from event where timestamp >
> 1226952050683 order by timestamp desc limit 10;

Turning on constraint exclusion might help here, if you have appropriate
check constraints for the range of timestamp attached to all the tables.

            regards, tom lane