On Mon, 2007-11-26 at 16:01 -0800, Alex Vinogradovs wrote:
> I've got a data warehouse with pretty high rate of insert into
> partitioned tables. What I've noticed, is that rule-based partitioning
> seems to be somewhat slower than insertions made directly into
> partitions through execution of dynamic SQL.
>
> Is it really true ?
Depends how complex your rules are, but I think yes is the short answer.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com