On Mon, Jul 03, 2006 at 14:59:49 +0200, Dragan Zubac <[EMAIL PROTECTED]> wrote: > > Is it possible to use transactions with 'per sub table' locks? What I > mean,if I partition a table and use transaction on that table with > constraint,will the database lock the master table (and all subtables),or > only sub table where the data is ?
Are you sure locking will be a problem? MVCC avoids a lot of typical conflicts. If you are doing something that is locking the tables in a way that causes problems, I think you will need to be more specific about what you are doing to get useful suggestions. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster