325 logon roles, 24 groups Doug
-----Original Message----- From: Guillaume Lelarge [mailto:[email protected]] Sent: Tuesday, August 03, 2010 2:49 PM To: Little, Douglas Cc: [email protected] Subject: Re: [pgadmin-support] Unexplained query activity. 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), > but why is it being executed so often. > > I had resource_groups selected in display. I've turned off, but not been > able to determine if it suppressed execution. > > Any thoughts? > How many roles do you have? 304? that would be the only reason why you should have this. If I'm right, this could be easy to fix. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-support mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
