On Tue, Jan 14, 2014 at 12:07 PM, knizhnik wrote:
> But is it possible to use index for derived table at all?
Yes, the planner will do an index scan when it makes sense.
> Why sequential search is used for derived table in the example below:
> insert into derived_table values (2,2);
> create in
From PostgreSQL manual:
"A serious limitation of the inheritance feature is that indexes
(including unique constraints) and foreign key constraints only apply to
single tables, not to their inheritance children."
But is it possible to use index for derived table at all?
Why sequential search i
