[Postgres-xl-developers] tablesample case of regression test

Tomas Vondra tomas.vondra at 2ndquadrant.com
Thu Oct 5 14:12:29 PDT 2017


On 09/28/2017 07:57 PM, Tomas Vondra wrote:
> 
> 
> On 09/27/2017 10:59 PM, Tomas Vondra wrote:
>> On 09/27/2017 08:46 PM, Tomas Vondra wrote:
>>> Hi,
>>>
>>> ...
>>>
>>> For replicated tables we end up using FQS, shipping the whole query to
>>> the remote node. And that simply can't support backward scans :-/
>>>
>>> So I think we need to disable FQS for cursors, and revert the rescan
>>> support added by d9f369f1af165f. Or do you have better ideas?
>>>
> 
> Barring objections, I'll push the attached patch (doing this and
> tweaking the cursors in limit.sql tests to use SCROLL) early next week.
> 

Pushed today.

regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


More information about the Postgres-xl-developers mailing list