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
