On Tue, Aug 9, 2016 at 2:01 PM, Ashesh Vashi <ashesh.va...@enterprisedb.com> wrote:
> On Tue, Aug 9, 2016 at 6:28 PM, Dave Page <dp...@pgadmin.org> wrote: > >> Hi >> >> On Tue, Aug 9, 2016 at 8:07 AM, Murtuza Zabuawala >> <murtuza.zabuaw...@enterprisedb.com> wrote: >> > Hi, >> > >> > PFA patch to fix the issue where message panel was showing incomplete >> info. >> > We may still miss some messages from Psycopg2 driver due to limited >> size of >> > notices queue. >> > (RM#1523) >> >> A few thoughts on this (mostly based on my discussions with Ashesh): >> >> 1) You seem to have removed the poll delay. I assume that is to try to >> avoid missing messages? Can we re-introduce the delay (to avoid >> excessive network requests), but collect messages while we're waiting? >> > Using thread? > Start a thread during the timeout? > Not necessarily. If we want a 2 second polling delay, we could just sleep for 0.5 secs, collect messages, sleep for 0.5 sec, collect messages, <repeat...> return to client. > >> 2) If I run VACUUM, whilst I see messages as I should now, there is no >> query time summary as there is for a query that returns data. >> > >> 3) Can we incrementally display messages? e.g. each time we poll, we >> add the new messages to the messages div, and scroll to the end >> automatically? > > Yeah - that's a good idea. > > -- > > Thanks & Regards, > > Ashesh Vashi > EnterpriseDB INDIA: Enterprise PostgreSQL Company > <http://www.enterprisedb.com/> > > > *http://www.linkedin.com/in/asheshvashi* > <http://www.linkedin.com/in/asheshvashi> > >> > > > > >> -- >> Dave Page >> Blog: http://pgsnake.blogspot.com >> Twitter: @pgsnake >> >> EnterpriseDB UK: http://www.enterprisedb.com >> The Enterprise PostgreSQL Company >> >> >> -- >> Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgadmin-hackers >> > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company