Skip site navigation (1) Skip section navigation (2)

Re: RES: Priority to a mission critical transaction

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org, Andreas Kostyrka <andreas(at)kostyrka(dot)org>, "Carlos H(dot) Reimer" <carlos(dot)reimer(at)opendb(dot)com(dot)br>, "Jim C(dot) Nasby" <jim(at)nasby(dot)net>, Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
Subject: Re: RES: Priority to a mission critical transaction
Date: 2006-11-29 01:11:12
Message-ID: 456CDE30.4010502@paradise.net.nz (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-performance
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

In response to

pgsql-performance by date

Next:From: Ron MayerDate: 2006-11-29 01:20:38
Subject: Re: RES: Priority to a mission critical transaction
Previous:From: Bruce MomjianDate: 2006-11-28 23:44:45
Subject: Re: RES: Priority to a mission critical transaction

pgsql-advocacy by date

Next:From: Ron MayerDate: 2006-11-29 01:20:38
Subject: Re: RES: Priority to a mission critical transaction
Previous:From: Bruce MomjianDate: 2006-11-28 23:44:45
Subject: Re: RES: Priority to a mission critical transaction

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group