Re: partitioning and locking problems

Marc Morin wrote:
> Under both these circumstances (truncate and create / replace rule) the
> locking behaviour of these commands can cause locking problems for us.
> The scenario is best illustrated as a series of steps:
>
>
>     1- long running report is running on view
>     2- continuous inserters into view into a table via a rule
>     3- truncate or rule change occurs, taking an exclusive lock.
> Must wait for #1 to finish.
>     4- new reports and inserters must now wait for #3.
>     5- now everyone is waiting for a single query in #1.   Results
> in loss of insert data granularity (important for our application).

How much would you get from splitting the view into two: reporting and
inserting?

--
   Richard Huxton
   Archonet Ltd