Re: Partial index creation always scans the entire table

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: MingJu Wu <mingjuwu0505(at)gmail(dot)com>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: Partial index creation always scans the entire table
Date: 2020-02-15 12:47:51
Message-ID: 10506951581770871@sas1-c38703ca5585.qloud-c.yandex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2020-02-15 12:53:30 Re: Partial index creation always scans the entire table
Previous Message MingJu Wu 2020-02-15 11:04:48 Partial index creation always scans the entire table