Re: Partial index creation always scans the entire table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux