From: tushar
Sent: Monday, September 27, 2021 11:50
To: Andrew Dunstan ; l...@laurent-hasson.com; Julien
Rouhaud
Cc: Tom Lane ; Ranier Vilela ; Justin
Pryzby ; pgsql-performa...@postgresql.org
Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
On 9/27/21 6:55 PM,
Kim Johan Andersson writes:
> [ uses partial index: ]
> EXPLAIN (analyze, costs, buffers, verbose) SELECT val FROM
> table_test_enum WHERE val = 'Ole' and dat IS NULL;
>
> [ doesn't: ]
> PREPARE qry1(varchar) AS SELECT val FROM table_test_enum WHERE val =
> $1::type_table_test_enum AND dat IS N
I have run into the following issue: A table contains an enum column,
and a partial unique index is available on the table.
This index contains exactly the row I am querying for. Unfortunately the
index is not always used, and I don't really understand why.
The attachments enumTest.sql shows
I
Hi Michael,
Thanks a lot for having a look at the query once again in more detail. In
short, you are right, I fired the liquibase scripts and observed the exact
query that was hanging in pg_stats_activity. The query was:
SELECT
FK.TABLE_NAME as "TABLE_NAME"
, CU.COLUMN_NAM
From: tushar
Sent: Monday, September 27, 2021 11:50
To: Andrew Dunstan ; l...@laurent-hasson.com; Julien
Rouhaud
Cc: Tom Lane ; Ranier Vilela ; Justin
Pryzby ; pgsql-performa...@postgresql.org
Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
On 9/27/21 6:55 PM,
On 9/27/21 6:55 PM, Andrew Dunstan wrote:
Hello Andrew,
I just download the 13.4 Windows x86-64 installer
fromhttps://www.enterprisedb.com/downloads/postgres-postgresql-downloads but
it's the exact same file bit for bit from the previous version I had. Am I
looking at the wrong place?
Than
I'm unclear what you changed to get the planner to choose one vs the other.
Did you disable hashjoins? Without the full plan to review, it is tough to
agre with any conclusion that these particular nodes are troublesome. It
might be that this was the right choice for that part of that plan, but
imp
On 9/25/21 9:33 PM, l...@laurent-hasson.com wrote:
>> > EDB has now published new installers for versions later than release
>> > 11, containing Postgres built with an earlier version of gettext that
>> > does not exhibit the problem. Please verify that these fix the issue.
>>
Hi Michael,
Thanks for the answer.
I agree that the tables behind the views makes the query processing
challenging. What makes it even more challenging to us is that this query
is generated by a third party library that we use to operationalize the
schema changes.
I am trying to figure out what
