Re: Strange performance degregation in sql function (PG11.1)

2019-05-23 Thread Pavel Stehule
lans - so creates and lost plans every time. > Best regards, > > Alastair > ---------- > *From:* Andrew Gierth > *Sent:* 19 May 2019 03:48 > *To:* Alastair McKinley > *Cc:* pgsql-general@lists.postgresql.org > *Subject:* Re: Strange performance degreg

Re: Strange performance degregation in sql function (PG11.1)

2019-05-23 Thread Alastair McKinley
fused me. Best regards, Alastair From: Andrew Gierth Sent: 19 May 2019 03:48 To: Alastair McKinley Cc: pgsql-general@lists.postgresql.org Subject: Re: Strange performance degregation in sql function (PG11.1) >>>>> "Alastair" == Alast

Re: Strange performance degregation in sql function (PG11.1)

2019-05-18 Thread Andrew Gierth
> "Alastair" == Alastair McKinley writes: Alastair> Hi all, Alastair> I recently experienced a performance degradation in an Alastair> operational system that I can't explain. I had a function Alastair> wrapper for a aggregate query that was performing well using Alastair> the expected

Re: Strange performance degregation in sql function (PG11.1)

2019-05-18 Thread Adrian Klaver
On 5/18/19 4:17 AM, Alastair McKinley wrote: Hi all, I recently experienced a performance degradation in an operational system that I can't explain.  I had a function wrapper for a aggregate query that was performing well using the expected indexes with the approximate structure as shown belo