Re: Possible optimisation: push down SORT and LIMIT nodes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Possible optimisation: push down SORT and LIMIT nodes
From: Justin Pryzby <pryzby@xxxxxxxxxxxxx>
Date: Wed, 30 May 2018 14:09:44 -0500
Cc: "pgsql-performance@xxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxx>, Steven Winfield <Steven.Winfield@xxxxxxxxxxxxxxxxx>
In-reply-to: <20180530190231.GH5164@telsasoft.com>
References: <BCCA73C2165E8947A2E786EC482564DE01301FB8F2@CCPMAILDAG03.cantab.local> <20180530190231.GH5164@telsasoft.com>
User-agent: Mutt/1.5.23 (2014-03-12)

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

References:
- Possible optimisation: push down SORT and LIMIT nodes
  - From: Christopher Wilson
- Re: Possible optimisation: push down SORT and LIMIT nodes
  - From: Justin Pryzby

Prev by Date: Re: Possible optimisation: push down SORT and LIMIT nodes
Next by Date: Sort is generating rows
Previous by thread: Re: Possible optimisation: push down SORT and LIMIT nodes
Next by thread: Sort is generating rows
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux