On Sat, Nov 29, 2025 at 12:57:46AM +0200, Andrus wrote:
> Hi!
>
> Table has index on name column:
>
> CREATE TABLE firma2.klient
> (
> kood character(12) primary key,
> nimi character(100),
> ...
> );
>
> CREATE INDEX IF NOT EXIS
Hi!
Seems to be already answered:
"It looks like reindex table firma2.klient restored index scan. create
index concurrently was used when lot of transactions using this table
where running"
Is it possible that reindex changes query from sequential scan to use
index ?
Andrus.
On 11/29/25 09:47, Andrus wrote:
Hi!
Seems to be already answered:
"It looks like reindex table firma2.klient restored index scan. create
index concurrently was used when lot of transactions using this table
where running"
Is it possible that reindex changes query from sequential scan to u
bly worked long time but
suddenly stopped working today.
Re-started whole windows server but problem persists.
Using
PostgreSQL 17.5 on x86_64-windows, compiled by msvc-19.43.34808, 64-bit
in Windows Server 2022 vers 21H2
Andrus.
Posted also in
https://stackoverflow.com/questions/79832
.
Re-started whole windows server but problem persists.
Using
PostgreSQL 17.5 on x86_64-windows, compiled by msvc-19.43.34808, 64-bit
in Windows Server 2022 vers 21H2
Andrus.
Posted also in
https://stackoverflow.com/questions/79832965/how-to-use-index-in-simple-select
