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