Postgres Pro
Downloads
Home   >   mailing lists

Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 - Mailing list pgsql-performance

From Heikki Linnakangas
Subject Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
Date
Msg-id 472300C4.70800@enterprisedb.com
Whole thread Raw
In response to Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1  (Anton <anton200@gmail.com>)
List pgsql-performance
Tree view 
Anton wrote:
> I repost here my original question "Why it no uses indexes?" (on
> partitioned table and ORDER BY indexed_field DESC LIMIT 1), if you
> mean that you miss this discussion.

As I said back then:

The planner isn't smart enough to push the "ORDER BY ... LIMIT ..."
below the append node.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

pgsql-performance by date:

Previous
From: Anton
Date:
Subject: Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
Next
From: Tom Lane
Date:
Subject: Re: Speed difference between select ... union select ... and select from partitioned_table