Postgres Pro
Downloads
Home   >   mailing lists

Re: Planner do seq scan on empty master partitioned table - Mailing list pgsql-performance

From Tom Lane
Subject Re: Planner do seq scan on empty master partitioned table
Date
Msg-id 29012.1470923427@sss.pgh.pa.us
Whole thread Raw
In response to Planner do seq scan on empty master partitioned table  (Andrey Zhidenkov <andrey.zhidenkov@gmail.com>)
List pgsql-performance
Tree view 
Andrey Zhidenkov <andrey.zhidenkov@gmail.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

pgsql-performance by date:

Previous
From: Andrey Zhidenkov
Date:
Subject: Planner do seq scan on empty master partitioned table
Next
From: Vladimir Borodin
Date:
Subject: Re: Planner do seq scan on empty master partitioned table