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
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

Reply via email to