From: | GPT <gptmailinglists(at)gmail(dot)com> |
---|---|
To: | Andres Freund <andres(at)anarazel(dot)de> |
Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: rw_redis_fdw: SQL Errors when statement is within a function |
Date: | 2018-10-25 14:54:39 |
Message-ID: | CADep2PN_T+frUJG07oKRJ0DfUALuuoaSbvKq_nposNNaSWjX2w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
So, this kind of switch after a few goes is a normal behavior or
something unexpected which will change in future?
I am asking in order to have my mind on incidents with similar behavior.
Tia
On 10/25/18, Andres Freund <andres(at)anarazel(dot)de> wrote:
> Hi,
>
> On 2018-10-25 11:43:39 +0200, GPT wrote:
>> I have faced an incident which, according to the developer, "The
>> problem seems to be that pgsql switches from a CONST sub-expression
>> into a FUNCEXPR after a few goes, ..."
>>
>> Please have a look at the following two links which describe the problem:
>>
>> https://github.com/nahanni/rw_redis_fdw/issues/13
>> https://github.com/nahanni/rw_redis_fdw/issues/14
>>
>> The first link (13) has to do with PG10.x version.
>> The second one (14) has to do with PG11 version in which the developer
>> traces the "problem".
>>
>> Please check and comment.
>
> The developer of the FDW seems to have made the requisite fixes. I'm not
> sure what you'd like us to do?
>
> Greetings,
>
> Andres Freund
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2018-10-25 17:43:06 | Re: Should pg 11 use a lot more memory building an spgist index? |
Previous Message | Ravi Krishna | 2018-10-25 14:39:29 | Re: Compile and build portable postgresql for mac |