Re: Partitioning: Planner makes no use of indexes on inherited

From: Stephen Friedrich <stephen(dot)friedrich(at)fortis-it(dot)de>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Partitioning: Planner makes no use of indexes on inherited
Date: 2006-01-18 09:12:57
Message-ID: 43CE0699.90006@fortis-it.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Nope. Same cost :-(

I am currently trying to find a way to intercept and modify
the sql generated by hibernate. There does not seem to be
any hook for general queries. My last resort will be to create
a jdbc driver as a wrapper.
Parsing the statement will not be trivial, though.

Still, even though it would be easy to fix with different SQL,
I think this is a shortcoming that postgres should fix.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Emil Rachovsky 2006-01-18 09:18:15 bug with if ... then ... clause in views
Previous Message Tino Wildenhain 2006-01-18 09:10:22 Re: PostgreSQL Top 10 Wishlist