* Greg Smith (g...@2ndquadrant.com) wrote:
> Craig Ringer wrote:
>> On 1/12/2009 11:33 AM, Greg Smith wrote:
>>> 1) If you spawn the psql process with bash using "&", you can then find
>>> its pid with "$!", then chain through the process tree with ps and
>>> pg_stat_activity as needed to figure ou
Craig Ringer wrote:
On 1/12/2009 11:33 AM, Greg Smith wrote:
1) If you spawn the psql process with bash using "&", you can then find
its pid with "$!", then chain through the process tree with ps and
pg_stat_activity as needed to figure out the backend pid.
I feel like I'm missing something ob
troys
Sent: Tuesday, December 01, 2009 4:18 AM
To: Craig Ringer
Cc: Greg Smith; pgsql-general@postgresql.org
Subject: Re: [GENERAL] limiting resources to users
On 1 Dec 2009, at 4:55, Craig Ringer wrote:
> On 1/12/2009 11:33 AM, Greg Smith wrote:
>> Craig Ringer wrote:
>>> I assum
On 1 Dec 2009, at 4:55, Craig Ringer wrote:
> On 1/12/2009 11:33 AM, Greg Smith wrote:
>> Craig Ringer wrote:
>>> I assume you look up the associated backend by looking up the source
>>> IP and port of the client with `netstat', `lsof', etc, and matching
>>> that to pg_stat_activity?
>> There's a
On 1/12/2009 11:33 AM, Greg Smith wrote:
Craig Ringer wrote:
I assume you look up the associated backend by looking up the source
IP and port of the client with `netstat', `lsof', etc, and matching
that to pg_stat_activity?
There's a bunch of ways I've seen this done:
1) If you spawn the psql
Craig Ringer wrote:
I assume you look up the associated backend by looking up the source
IP and port of the client with `netstat', `lsof', etc, and matching
that to pg_stat_activity?
There's a bunch of ways I've seen this done:
1) If you spawn the psql process with bash using "&", you can then
On 1/12/2009 12:30 AM, Greg Smith wrote:
Craig Ringer wrote:
I've also added a general explanation of the issues with prioritizing
users/queries/connections/databases:
http://wiki.postgresql.org/wiki/Priorities
I just spent some time
reviewing/improving your article, and I pulled the disclai
Craig Ringer wrote:
I've also added a general explanation of the issues with prioritizing
users/queries/connections/databases:
http://wiki.postgresql.org/wiki/Priorities
This is a very common question and I'm glad to have somewhere we just
point people to when it comes up again. I just spen
Gauthier, Dave wrote:
> Actually, limiting resources on a per DB basis would work for me too.
>
> I thin kOracle had a thing where you could limit resources, or at least
> prioritize users.
Pg isn't Oracle - for which we can be alternately extremely thankful and
somewhat frustrated. Lots of shin
ssage-
From: Craig Ringer [mailto:cr...@postnewspapers.com.au]
Sent: Wednesday, November 25, 2009 8:43 PM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] limiting resources to users
Gauthier, Dave wrote:
> Is there a way in Postgres to limit how much cpu, memory, othe
Craig Ringer wrote:
> Gauthier, Dave wrote:
>
>> Is there a way in Postgres to limit how much cpu, memory, other
>> resources a certain DB gets? A MySQL DB that I'm now replacing with PG
>> has been having problems with run-away users that pound one DB with
>> intense processes running periodicall
Gauthier, Dave wrote:
> Is there a way in Postgres to limit how much cpu, memory, other
> resources a certain DB gets? A MySQL DB that I'm now replacing with PG
> has been having problems with run-away users that pound one DB with
> intense processes running periodically in cron jobs. The effect i
no way for PostgreSQL to have something like Profiles to limite
ressource usage for users?
Is this feature planned for next version? 8-)
Jean-Yves F. Barbier a écrit :
Gauthier, Dave a écrit :
Hi:
Is there a way in Postgres to limit how much cpu, memory, other
resources a certain DB ge
Bill Moran a écrit :
> In response to "Gauthier, Dave" :
>
>> Hi:
>>
>> Is there a way in Postgres to limit how much cpu, memory, other resources a
>>certain DB gets? A MySQL DB that I'm now replacing with PG has been having
>>problems with run-away users that pound one DB with intense processe
In response to "Gauthier, Dave" :
> Hi:
>
> Is there a way in Postgres to limit how much cpu, memory, other resources a
> certain DB gets? A MySQL DB that I'm now replacing with PG has been having
> problems with run-away users that pound one DB with intense processes running
> periodically i
Gauthier, Dave a écrit :
> Hi:
>
>
>
> Is there a way in Postgres to limit how much cpu, memory, other
> resources a certain DB gets? A MySQL DB that I’m now replacing with PG
> has been having problems with run-away users that pound one DB with
> intense processes running periodically in cron
Gauthier, Dave wrote:
Hi:
Is there a way in Postgres to limit how much cpu, memory, other
resources a certain DB gets? A MySQL DB that I’m now replacing with PG
has been having problems with run-away users that pound one DB with
intense processes running periodically in cron jobs. The effect
17 matches
Mail list logo
