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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
