Re: How to use index in simple select

From: Andrus <kobruleht2(at)hot(dot)ee>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to use index in simple select
Date: 2025-11-29 17:47:23
Message-ID: 432c3538-e3b8-4e51-ad78-a30acddb5496@hot.ee
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-11-29 17:56:31 Re: How to use index in simple select
Previous Message Adrian Klaver 2025-11-29 17:27:43 Re: How to use index in simple select