Request a Demo
Home   >   mailing lists

Re: [BUGS] BUG #11500: PRIMARY KEY index not being used - Mailing list pgsql-bugs

From David Rowley
Subject Re: [BUGS] BUG #11500: PRIMARY KEY index not being used
Date
Msg-id CAApHDvofqveLN+EAFeKim3Ppd5BQp1z1irzWhXOCu6_0gGxjug@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #11500: PRIMARY KEY index not being used  (Marko Tiikkaja <marko@joh.to>)
List pgsql-bugs
Tree view 
On Mon, 6 Oct 2025 at 23:39, Marko Tiikkaja <marko@joh.to> wrote:
> On the production server the query still consistently took ~100ms even
> after all that maintenance had been done.  Compared to <0.05ms when
> going through the primary key.

This part surprises me. Is this on a standby server or primary? Are
you certain that no rows are matching the state = 'WAIT_EVENT' qual?

David

pgsql-bugs by date:

Previous
From: Álvaro Herrera
Date:
Subject: Re: BUG #19074: pg_dump from v18 loses the NOT NULL flag in the inherited table field when dumping v17-databases
Next
From: Dilip Kumar
Date:
Subject: Re: BUG #19074: pg_dump from v18 loses the NOT NULL flag in the inherited table field when dumping v17-databases