On Thu, 2023-09-21 at 17:05 +0200, Koen De Groote wrote:
> I'm doing the following query:
> select * from my_table where hasbeenchecked = true and hasbeenverified = true
> and insert_timestamp <= '2023-09-01 00:00:00.000' limit 1000;
>
> The date is an example, it is the format that is used in th
I'm researching a query that's slow occasionally, and I'm seeing dirtied
reads and am asking for some help in understanding.
The table has the following relevant fields:
- insert_timestamp (timestamp without timezone, nullable, default now())
- hasbeenchecked ( boolean, not null )
- hasbeenverifie
