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.