Postgres Pro
Downloads
Home   >   mailing lists

[pgAdmin III] #221: A Greenplum query is executed once per role - Mailing list pgadmin-hackers

From pgAdmin Trac
Subject [pgAdmin III] #221: A Greenplum query is executed once per role
Date
Msg-id 056.7709bb41fdae3c7907bb0f2b55c28bf8@code.pgadmin.org
Whole thread Raw
Responses Re: [pgAdmin III] #221: A Greenplum query is executed once per role
List pgadmin-hackers
Tree view 
#221: A Greenplum query is executed once per role
-----------------------------+----------------------------------------------
 Reporter:  Little, Douglas  |       Owner:  gleu
     Type:  feature          |      Status:  new 
 Priority:  minor            |   Milestone:      
Component:  pgadmin          |     Version:  1.10
 Keywords:  role greenplum   |    Platform:  all 
-----------------------------+----------------------------------------------
 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?

 2010-08-03 14:15:18.654622 CDT

 LOG

 statement: SELECT rsqname FROM pg_resqueue WHERE pg_resqueue.oid = 1496028

 con755

 cmd15

 postgres

 ....  303 rows identical calls.

--
Ticket URL: <http://code.pgadmin.org/trac/ticket/221>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III

pgadmin-hackers by date:

Previous
From: Chuck McDevitt
Date:
Subject: Re: Patch on roles query for pgAdmin with a Greenplum database
Next
From: Guillaume Lelarge
Date:
Subject: pgAdmin III commit: Don't send the Greenplum query for each user, but i