"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > Heh, o.k. that was an ambiguous sentence. In a partitioned environment > you are likely not moving millions of rows around. Thus the "rule" > benefit is lost. You are instead performing many (sometimes > lots-o-many) inserts and updates that involve a small number of rows.
I'm still not following at all. If you're partitioning it's because you have a *lot* of data. It doesn't say anything about what you're doing with that data. Partitioning is useful for managing large quantities of data for both OLTP and DSS systems. I tend to be happier recommending triggers over rules if only because rules are just harder to understand. Arguably they don't really work properly for this use anyways given what happens if you use volatile functions like random() in your where clause. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
