Re: Test tidscan,sql is not immune to autovacuum in v14 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Test tidscan,sql is not immune to autovacuum in v14
Date
Msg-id 3537961.1787201023@sss.pgh.pa.us
Whole thread
In response to Re: Test tidscan,sql is not immune to autovacuum in v14  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: [PATCH v1] PL/Perl: Fix NULL deref for forged array
List pgsql-hackers
David Rowley <dgrowleyml@gmail.com> writes:
> Another way to make the alternative join order less favourable would
> be with something like:

> select count(*) from tenk1 t1 inner join tenk1 t2 on t1.ctid = t2.ctid
> where t2.ten = 0;

Sure, that'd work for me.

            regards, tom lane



Attachment

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Test tidscan,sql is not immune to autovacuum in v14
Next
From: Amit Kapila
Date:
Subject: Re: Logical replication row filter loses unchanged toasted columns