On Tue, Apr 21, 2009 at 9:38 AM, Kedar Potdar <kedar(dot)potdar(at)gmail(dot)com> wrote:
> Currently, such records are left in the overflow partition and its
> responsibility
> of user to insert them into partitioned-table which will then re-direct
> those to
> appropriate partitions.
This doesn't sound like a very good idea, because the planner cannot
then rely on the overflow table not containing tuples that ought to be
within some other partition.
The big win that is associated with table partitioning is using
constraint exclusion to avoid unnecessary partitions scans.
...Robert