Re: Partial index creation always scans the entire table

Hello

> When creating partial indexes, can postgres utilize another index for figuring which rows should be included in the
partialindex, without performing a full table scan?
 

No.
create index always perform a seqscan on table. And two full table scan for create index concurrently.

regards, Sergei