RE: FW: Possible optimisation: push down SORT and LIMIT nodes

2018-06-01 Thread Steven Winfield
.org; Steven Winfield Subject: Re: FW: Possible optimisation: push down SORT and LIMIT nodes The incremental sort patch seems to significantly improve performance for your query: https://commitfest.postgresql.org/17/1124/<https://commitfest.postgresql.org/17/1124/> On Fri, Jun 1, 2018 at 7:

Re: FW: Possible optimisation: push down SORT and LIMIT nodes

2018-06-01 Thread James Coleman
The incremental sort patch seems to significantly improve performance for your query: https://commitfest.postgresql.org/17/1124/ On Fri, Jun 1, 2018 at 7:46 AM, Christopher Wilson < chris.wil...@cantabcapital.com> wrote: > Dear Postgres developers, > > > > I sent this query to the performance lis