Re: ExecRTCheckPerms() and many prunable partitions

From: Andres Freund <andres(at)anarazel(dot)de>
To: Amit Langote <amitlangote09(at)gmail(dot)com>, Justin Pryzby <pryzbyj(at)telsasoft(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, David Rowley <dgrowleyml(at)gmail(dot)com>, Greg Stark <stark(at)mit(dot)edu>, Zhihong Yu <zyu(at)yugabyte(dot)com>, Julien Rouhaud <rjuju123(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: ExecRTCheckPerms() and many prunable partitions
Date: 2022-10-02 17:10:36
Message-ID: 20221002171036.6mwek7qdscis33ia@awork3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On 2022-09-07 18:23:06 +0900, Amit Langote wrote:
> Attached updated patches.

Thanks to Justin's recent patch (89d16b63527) to add
-DRELCACHE_FORCE_RELEASE -DCOPY_PARSE_PLAN_TREES -DWRITE_READ_PARSE_PLAN_TREES -DRAW_EXPRESSION_COVERAGE_TEST
to the FreeBSD ci task we now see the following:

https://cirrus-ci.com/task/4772259058417664
https://api.cirrus-ci.com/v1/artifact/task/4772259058417664/testrun/build/testrun/main/regress/regression.diffs

diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/updatable_views.out /tmp/cirrus-ci-build/build/testrun/main/regress/results/updatable_views.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/updatable_views.out 2022-10-02 10:37:08.888945000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/main/regress/results/updatable_views.out 2022-10-02 10:40:26.947887000 +0000
@@ -1727,14 +1727,16 @@
(4 rows)

UPDATE base_tbl SET id = 2000 WHERE id = 2;
+WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree
UPDATE rw_view1 SET id = 3000 WHERE id = 3;
+WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree
SELECT * FROM base_tbl;
id | idplus1
------+---------
1 | 2
4 | 5
- 2000 | 2001
- 3000 | 3001
+ 2000 | 3
+ 3000 | 4
(4 rows)

DROP TABLE base_tbl CASCADE;

and many more.

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2022-10-02 17:12:26 Re: Question: test "aggregates" failed in 32-bit machine
Previous Message Andres Freund 2022-10-02 17:04:24 Re: [PoC] Improve dead tuple storage for lazy vacuum