Re: RES: Priority to a mission critical transaction

[Mark Kirkwood <markir@xxxxxxxxxxxxxxx>]

Josh Berkus wrote:
> All,
>
> The Bizgres project is working on resource management for PostgreSQL.  So far, 
> however, they have been able to come up with schemes that work for BI/DW at 
> the expense of OLTP.  Becuase of O^N lock checking issues, resource 
> management for OLTP which doesn't greatly reduce overall performance seems a 
> near-impossible task.
Right - I guess it is probably more correct to say that the 
implementation used in Bizgres is specifically targeted at BI/DW 
workloads rather than OLTP.
At this point we have not measured its impact on concurrency in anything 
other than a handwaving manner - e.g pgbench on an older SMP system 
showed what looked like about a 10% hit. However the noise level for 
pgbench is typically >10% so - a better benchmark on better hardware is 
 needed.
Cheers

Mark