Hello > When creating partial indexes, can postgres utilize another index for > figuring which rows should be included in the partial index, 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