Re: Planner do seq scan on empty master partitioned table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrey Zhidenkov <andrey(dot)zhidenkov(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Planner do seq scan on empty master partitioned table
Date: 2016-08-11 13:50:27
Message-ID: 29012.1470923427@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Andrey Zhidenkov <andrey(dot)zhidenkov(at)gmail(dot)com> writes:
> I have a table (registry.entry) which has ~ 100 inherited tables. This
> is a master table and it's empty:

As long as it's empty, a seqscan should be essentially free. Don't
worry about it. And definitely don't create indexes, that will just
add cost.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Vladimir Borodin 2016-08-11 13:55:49 Re: Planner do seq scan on empty master partitioned table
Previous Message Andrey Zhidenkov 2016-08-11 10:46:47 Planner do seq scan on empty master partitioned table