Re: Transaction and table partitioning
От
Bruno Wolff III
Тема
Re: Transaction and table partitioning
Дата
Msg-id
20060703170340.GA9567@wolff.to
Ответ на
Transaction and table partitioning (Dragan Zubac)
Список
Дерево обсуждения
Transaction and table partitioning "Dragan Zubac" <zubacdragan@gmail.com>
Re: Transaction and table partitioning Simon Riggs <simon@2ndquadrant.com>
Re: Transaction and table partitioning Bruno Wolff III <bruno@wolff.to>
Re: Transaction and table partitioning Greg Stark <gsstark@mit.edu>
On Mon, Jul 03, 2006 at 14:59:49 +0200, Dragan Zubac 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.
В списке pgsql-hackers по дате отправления
