Re: RES: [PERFORM] Priority to a mission critical transaction

2006-11-29 Thread Josh Berkus
Bruce, > Someone should ask them to remove the article. "Someone". Um, *who* taught for Big Nerd Ranch for several years, Bruce? -- Josh Berkus PostgreSQL @ Sun San Francisco ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, ple

Re: RES: [PERFORM] Priority to a mission critical transaction

2006-11-28 Thread Mark Kirkwood
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 redu

Re: RES: [PERFORM] Priority to a mission critical transaction

2006-11-28 Thread Bruce Momjian
Someone should ask them to remove the article. --- Tom Lane wrote: > "Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > > There is an article about "Lowering the priority of a PostgreSQL query" > > (http://weblog.bignerdranch.

Re: RES: [PERFORM] Priority to a mission critical transaction

2006-11-28 Thread Josh Berkus
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 performanc

Re: RES: [PERFORM] Priority to a mission critical transaction

2006-11-28 Thread Andreas Kostyrka
* Carlos H. Reimer <[EMAIL PROTECTED]> [061128 20:02]: > Hi, > > There is an article about "Lowering the priority of a PostgreSQL query" > (http://weblog.bignerdranch.com/?p=11) that explains how to use the > setpriority() to lower PostgreSQL processes. > > I?m wondering how much effective it wou

Re: RES: [PERFORM] Priority to a mission critical transaction

2006-11-28 Thread Tom Lane
"Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > There is an article about "Lowering the priority of a PostgreSQL query" > (http://weblog.bignerdranch.com/?p=11) that explains how to use the > setpriority() to lower PostgreSQL processes. > I?m wondering how much effective it would be for i/o bound