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

From Richard Huxton
Subject Re: Partitioning: Planner makes no use of indexes on inherited
Date
Msg-id 43CE04D5.6020101@archonet.com
Whole thread Raw
In response to Partitioning: Planner makes no use of indexes on inherited table?!  (Stephen Friedrich <stephen.friedrich@fortis-it.de>)
Responses Re: Partitioning: Planner makes no use of indexes on inherited
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Change owner of all database objects
Next
From: Tino Wildenhain
Date:
Subject: Re: PostgreSQL Top 10 Wishlist