On 8/1/06, Chris Mair <[EMAIL PROTECTED]> wrote:
On Tue, 2006-08-01 at 14:22 -0500, Scott Marlowe wrote:> On Tue, 2006-08-01 at 13:59, Aaron Bono wrote:> > Is there a way to tell PostgreSQL to change the nice value of a> > particular connection? I guess I could use renice but that means a
> > lot
On Tue, 2006-08-01 at 14:22 -0500, Scott Marlowe wrote:
> On Tue, 2006-08-01 at 13:59, Aaron Bono wrote:
> > On 7/31/06, Thomas Pundt <[EMAIL PROTECTED]> wrote:
> > On Monday 31 July 2006 10:06, Aaron Bono wrote:
> > | Is there a way I can tell PostgreSQL to give session a low
> >
On 8/1/06, Scott Marlowe <[EMAIL PROTECTED]> wrote:
On Tue, 2006-08-01 at 13:59, Aaron Bono wrote:> On 7/31/06, Thomas Pundt <[EMAIL PROTECTED]> wrote:> On Monday 31 July 2006 10:06, Aaron Bono wrote:
> | Is there a way I can tell PostgreSQL to give session a low> priority s
Bottom line, I am skeptical if this will really achieve my goal - to
have the functions run with low priority.
Is there a way to tell PostgreSQL to change the nice value of a
particular connection? I guess I could use renice but that means a lot
of shell scripting to determine what PID to c
On Tue, 2006-08-01 at 13:59, Aaron Bono wrote:
> On 7/31/06, Thomas Pundt <[EMAIL PROTECTED]> wrote:
> On Monday 31 July 2006 10:06, Aaron Bono wrote:
> | Is there a way I can tell PostgreSQL to give session a low
> priority so even
> | if it does take the full CPU,
On 7/31/06, Thomas Pundt <[EMAIL PROTECTED]> wrote:
On Monday 31 July 2006 10:06, Aaron Bono wrote:| Is there a way I can tell PostgreSQL to give session a low priority so even| if it does take the full CPU, it only does so if it would otherwise be| idle?
the "nice" command might do what you want..
On Monday 31 July 2006 10:06, Aaron Bono wrote:
| Is there a way I can tell PostgreSQL to give session a low priority so even
| if it does take the full CPU, it only does so if it would otherwise be
| idle?
the "nice" command might do what you want...
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTEC
I have a nightly process that runs in production to refresh reports. This process runs fine but takes a significant portion of the CPU for an hour or so. I was wanting to limit this particular process so it does not consume the full CPU while running (unless nothing else needs the CPU cycles anyw
