On Fri, Sep 22, 2023 at 5:44 AM Koen De Groote wrote:
> Alright.
>
> So, if I want to speed up the query, apart from trying to vacuum it
> beforehand, I suspect I've hit the limit of what this query can do?
>
It is more a limit on the system as a whole, not just one query. How is
this table bei
The "select * " is a replacement for the actual fields, which are all
queried. I simply want to avoid pasting the entire query. The names that
are there, too, are edited.
>From what I'm reading, my best chance is to limit the amount of variables I
need and change to index, plus tune for more frequ
The actual thing that might be good to see is the query plan (explain).
It is commonly regarded an issue to select ‘*’, in many cases only a subset of
the rows are needed, but I don’t know your exact case.
If a limited number of columns are actually needed from the table, it might
help to create
On Fri, 2023-09-22 at 10:35 +0200, Koen De Groote wrote:
> On Thu, Sep 21, 2023 at 9:30 PM Laurenz Albe wrote:
> > 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 =
> > > tru
Alright.
So, if I want to speed up the query, apart from trying to vacuum it
beforehand, I suspect I've hit the limit of what this query can do?
Because, the table is just going to keep growing. And it's a usually a
query that runs one time per day, so it's a cold run each time.
Is this just goi
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
