Re: Possible optimisation: push down SORT and LIMIT nodes

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Christopher Wilson <chris(dot)wilson(at)cantabcapital(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>, Steven Winfield <Steven(dot)Winfield(at)cantabcapital(dot)com>
Subject: Re: Possible optimisation: push down SORT and LIMIT nodes
Date: 2018-05-30 19:09:44
Message-ID: 20180530190944.GA25841@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Nicolas Seinlet 2018-05-31 11:22:57 Sort is generating rows
Previous Message Justin Pryzby 2018-05-30 19:02:31 Re: Possible optimisation: push down SORT and LIMIT nodes