public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: Marcelo Fernandes <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Best way to check if a table is empty
Date: Sun, 23 Mar 2025 21:15:32 -0700
Message-ID: <CAKFQuwbXZ+9tY=graDAWfFaxeOOpdOoQ+JtjmaqWCWfZc-PF4g@mail.gmail.com> (raw)
In-Reply-To: <CAKFQuwY_N9QeJZJ3sgYC7Ui0nohZVX5NCzELanXKmpiVgxZbag@mail.gmail.com>
References: <CAM2F1VMbOEubpXk44B5KaWKX0OSVrA8-9xqidhJMNtDprhTSTg@mail.gmail.com>
<CAKFQuwY_N9QeJZJ3sgYC7Ui0nohZVX5NCzELanXKmpiVgxZbag@mail.gmail.com>
On Sunday, March 23, 2025, David G. Johnston <[email protected]>
wrote:
>
> Maybe IOS helps though I do wonder whether a sequential scan skips over
> known all-dead pages making that relative benefit go away.
>
Well, no, since it tracks known visible, not known non-visible, though for
something like a fast exists test with no where clause if the VM had any 1
bits the answer to the exists would be yes. No idea if we take that
shortcut.
David J.
view thread (6+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Best way to check if a table is empty
In-Reply-To: <CAKFQuwbXZ+9tY=graDAWfFaxeOOpdOoQ+JtjmaqWCWfZc-PF4g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox