Re: [ADMIN] Priorities for users or queries?

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [ADMIN] Priorities for users or queries?
Date: 2007-02-11 18:13:08
Message-ID: 20070211181307.GA28557@a-kretschmer.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-hackers

am Sun, dem 11.02.2007, um 12:37:57 -0500 mailte Tom Lane folgendes:
> Andreas Kretschmer <akretschmer(at)spamfence(dot)net> writes:
> > You can retrieve the PID and the username of running querys in
> > pg_stat_activity. Perhaps, with this knowledge and an untrusted language
> > you can run system-commands such renice to change the priority of
> > running postmaster-processes.
>
> See "priority inversion" in the archives.

Thanks for the hint, i have seen 'Magnus Hagander's mail ;-)

Btw.: thanks you and others for your excellent work to improve
PostgreSQL. I'm only a customer, but i want to help others.

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Richard Huxton 2007-02-12 08:19:15 Re: [SQL] Password Policy
Previous Message Benjamin Arai 2007-02-11 18:02:01 Re: Priorities for users or queries?

Browse pgsql-general by date

  From Date Subject
Next Message marcelo Cortez 2007-02-11 21:19:46 Re: How to preserve characters with accent?
Previous Message Benjamin Arai 2007-02-11 18:02:01 Re: Priorities for users or queries?

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2007-02-11 18:16:22 Re: HOT for PostgreSQL 8.3
Previous Message Benjamin Arai 2007-02-11 18:02:01 Re: Priorities for users or queries?