On Mon, 2007-07-23 at 11:46 -0300, Tiago Daniel Jacobs wrote: > Tom and Gregory. U're right! The problem is that we're using > constraints for partitioned tables and by definition, a partition > never, absolutely never, can affect the entire system. > Yeh, the problem is that partitioning uses additional information to avoid reading data. The additional information and the actual data need to be kept in step, so at some point we may need to re-write that data and we'll always need a lock to do that.
So whether we use constraints, segment headers or what have you, there'll still be a need to lock and be locked out. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
