Postgres Pro
Downloads
Home   >   mailing lists

Re: Possible optimisation: push down SORT and LIMIT nodes - Mailing list pgsql-performance

From Justin Pryzby
Subject Re: Possible optimisation: push down SORT and LIMIT nodes
Date
Msg-id 20180530190944.GA25841@telsasoft.com
Whole thread Raw
In response to Re: Possible optimisation: push down SORT and LIMIT nodes  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-performance
Tree view 
On Wed, May 30, 2018 at 02:02:31PM -0500, Justin Pryzby wrote:
> For diagnostic purposes, I was able to to vastly improve the query runtime with
> a CTE (WITH):

I realized this was broken as soon as I sent it (for the essential reason of
discarding rows before having sorted them).  Sorry for the noise.

Justin

pgsql-performance by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: Possible optimisation: push down SORT and LIMIT nodes
Next
From: Nicolas Seinlet
Date:
Subject: Sort is generating rows