Re: [pgadmin-support] Unexplained query activity.

2010-08-09 Thread Guillaume Lelarge
Le 04/08/2010 00:22, Guillaume Lelarge a écrit : > Le 03/08/2010 22:08, Guillaume Lelarge a écrit : >> Le 03/08/2010 21:50, Little, Douglas a écrit : >>> 325 logon roles, 24 groups >>> >> >> I suppose some of them don't have a ressource queue configured. >> >> BTW, please, don't top-post. >> > >

Re: [pgadmin-support] Unexplained query activity.

2010-08-03 Thread Guillaume Lelarge
Le 03/08/2010 22:08, Guillaume Lelarge a écrit : > Le 03/08/2010 21:50, Little, Douglas a écrit : >> 325 logon roles, 24 groups >> > > I suppose some of them don't have a ressource queue configured. > > BTW, please, don't top-post. > If you can compile it on windows, here is a patch that shoul

Re: [pgadmin-support] Unexplained query activity.

2010-08-03 Thread Greg Smith
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 queri

Re: [pgadmin-support] Unexplained query activity.

2010-08-03 Thread Guillaume Lelarge
Le 03/08/2010 21:50, Little, Douglas a écrit : > 325 logon roles, 24 groups > I suppose some of them don't have a ressource queue configured. BTW, please, don't top-post. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@pos

Re: [pgadmin-support] Unexplained query activity.

2010-08-03 Thread Little, Douglas
325 logon roles, 24 groups Doug -Original Message- From: Guillaume Lelarge [mailto:guilla...@lelarge.info] Sent: Tuesday, August 03, 2010 2:49 PM To: Little, Douglas Cc: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] Unexplained query activity. Le 03/08/2010 21:38

Re: [pgadmin-support] Unexplained query activity.

2010-08-03 Thread Guillaume Lelarge
Le 03/08/2010 21:38, Little, Douglas a écrit : > [...] > Running PGAdmin 1.10.3 on win xp sp3 against Greenplum 3.3.6.6 (PG 8.1.4) > I'm looking over my pgadmin log and seeing frequent executions of these > queries. > In this particular instance, the sql was executed 304 times (in 2 seconds), >

[pgadmin-support] Unexplained query activity.

2010-08-03 Thread Little, Douglas
Hi, Running PGAdmin 1.10.3 on win xp sp3 against Greenplum 3.3.6.6 (PG 8.1.4) I'm looking over my pgadmin log and seeing frequent executions of these queries. In this particular instance, the sql was executed 304 times (in 2 seconds), but why is it being executed so often. I had resource_groups