Re: How to use index in simple select

Andrus <kobruleht2@hot.ee>

From: Andrus <kobruleht2@hot.ee>
To: Adrian Klaver <adrian.klaver@aklaver.com>, pgsql-general <pgsql-general@postgresql.org>
Date: 2025-11-29T17:47:23Z
Lists: pgsql-general
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.