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,
affect i/o queue too?
Reimer
-Mensagem original-
De: Jim C. Nasby [mailto:[EMAIL PROTECTED]
Enviada em: domingo, 26 de novembro de 2006 22:52
Para: Brad Nicholson
Cc: [EMAIL PROTECTED]; pgsql-performance@postgresql.org
Assunto: Re: [PERFORM] Priority to a mission critical transaction
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 systems.
* 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 would be for
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
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.com/?p=11)
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
On Tue, 2006-11-21 at 21:43 -0200, Carlos H. Reimer wrote:
Hi,
We have an application that is mission critical, normally very fast,
but when an I/O or CPU bound transaction appears, the mission critical
application suffers. Is there a way go give some kind of priority to
this kind of
Hi,
We have an application that is mission critical, normally very fast, but
when an I/O or CPU bound transaction appears, the mission critical
application suffers. Is there a way go give some kind of priority to this
kind of application?
Reimer