From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
---|---|
To: | "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com> |
Cc: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Unexplained query activity. |
Date: | 2010-08-03 20:20:58 |
Message-ID: | 4C587A2A.20903@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Little, Douglas wrote:
> Running PGAdmin 1.10.3 on win xp sp3 against Greenplum 3.3.6.6 (PG 8.1.4)
>
I think you mean PG 8.2.4 there.
If you're not already familiar with how Greenplum uses resource queues,
some background there might help explain why the things you're looking
at require queries against it:
http://www.greenplum.com/docs/3300/CREATE_RESOURCE_QUEUE.html
http://www.greenplum.com/docs/3300/sql-alterrole.html
http://www.greenplum.com/docs/3300/DROP_RESOURCE_QUEUE.html
The DROP page in particular shows examples that retrieve similar things
to the pg_resqueue query you're seeing run.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2010-08-03 22:22:16 | Re: Unexplained query activity. |
Previous Message | Guillaume Lelarge | 2010-08-03 20:08:26 | Re: Unexplained query activity. |