ist a couple of days ago, but nobody
>>> has come up with any suggestions. I was wondering if you’d like to consider
>>> it?
>>>
>>> If this is interesting but nobody has time to implement it, then I would
>>> potentially be willing to implement an
essing the feature-freeze for v11 means we won’t see this in the that
>> version, though, and the extra GUC it requires means it will be in v12 at
>> the earliest?
>>
>> From: James Coleman [mailto:jtc...@gmail.com]
>> Sent: 01 June 2018 13:50
>> To: Chri
opher Wilson
> Sent: 30 May 2018 16:47
> To: 'pgsql-performa...@postgresql.org
> <mailto:pgsql-performa...@postgresql.org>'
> Cc: Steven Winfield (steven.winfi...@cantabcapital.com
> <mailto:steven.winfi...@cantabcapital.com>)
> Subject: Possible optimisati
.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:
t;
>
>
> *From:* Christopher Wilson
> *Sent:* 30 May 2018 16:47
> *To:* 'pgsql-performa...@postgresql.org'
> *Cc:* Steven Winfield (steven.winfi...@cantabcapital.com)
> *Subject:* Possible optimisation: push down SORT and LIMIT nodes
>
>
>
> H
opher Wilson
Sent: 30 May 2018 16:47
To: 'pgsql-performa...@postgresql.org'
Cc: Steven Winfield (steven.winfi...@cantabcapital.com)
Subject: Possible optimisation: push down SORT and LIMIT nodes
Hi all,
We have a query which is rather slow (about 10 seconds), and it looks like this:
select
