Request a Demo
Home   >   mailing lists

Re: How to use index in simple select - Mailing list pgsql-general

From Andrus
Subject Re: How to use index in simple select
Date
Msg-id 432c3538-e3b8-4e51-ad78-a30acddb5496@hot.ee
Whole thread Raw
In response to Re: How to use index in simple select  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view

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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to use index in simple select
Next
From: Adrian Klaver
Date:
Subject: Re: How to use index in simple select