Re: Partitioning: Planner makes no use of indexes on inherited - Mailing list pgsql-general

Stephen Friedrich wrote:
> Here is the plan if I query the inherited table directly
> (which is not really possible to do with that stupid, inflexible
> hibernate framework):
>
> explain select this_.id as id1_0_, <more columns>
> from call_sources_10554 this_
> where this_.cdr_id = 10554
> order by this_.id asc
> limit 100;

I don't suppose changing it to:
   ORDER BY this_.cdr_id, this_.id
does anything for you?

--
   Richard Huxton
   Archonet Ltd