CREATE INDEX uses INDEX ? - Mailing list pgsql-performance

From Nicolas Paris
Subject CREATE INDEX uses INDEX ?
Date
Msg-id CA+ssMORCq8kF1T0U6woF_Qjs5DCvHQfLCbF0-0=YT2=w3HbTvg@mail.gmail.com
Whole thread Raw
Responses Re: CREATE INDEX uses INDEX ?  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-performance
Hello,

I wonder if the process of index creation can benefit from other indexes.

EG: Creating a partial index with predicat based on a boolean column, will use an hypothetic index on that boolean column or always use a seq scan on all rows ?

Goal is to create partial indexes faster.

Explain command does not work with Create index.

Thanks by advance  

Nicolas PARIS

pgsql-performance by date:

Previous
From: Jeff Janes
Date:
Subject: Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
Next
From: Guillaume Lelarge
Date:
Subject: Re: CREATE INDEX uses INDEX ?