Re: Table Partitioning Advice Request

Vincenzo Romano <vincenzo.romano@notorand.it> writes:
> Is there any performance study for the trigger-based implementation?

Consider that if you use RULE to partition, when you DROP a partition
the INSERTs are locked out because the query depends on the table being
droped.

That alone could lead you to stop considering RULEs for partitioning.
--
dim