Re: Server Status window work

On Tue, Jan 27, 2009 at 2:30 PM, Guillaume Lelarge
<guillaume(at)lelarge(dot)info> wrote:
> The patch attached adds the control on the activity status tab. If the
> UI glitch the previous patch had doesn't appear with this one on
> Windows, it could be interesting to add them on the three remaining
> ones. Unfortunately, I can't check this this week (I won't have access
> to a Windows PC till next week).
>
> Can someone check this?

Looks good on Windows :) I see the buttons on each tab, but the slider
just on one which is what I guess you mean be 'add them on the three
remaining ones'.

> So, what's next? would the patch be rejected if wxAUI_NB_TAB_SPLIT is
> disabled? should I still work on this patch?

Well, if it's rejected it'll be by mutual agreement. I like the
feature enough that I think it probably should be enabled on Windows
and Mac, and disabled on GTK until the wx folks can fix things. It
would be worth logging/updating the bug with them.

> On my todo list, I have now:
>
> * add copy of the query running on the selected backend (button before
> Cancel Query)
>
> * activity view : color coding
> * new configuration tab (Server Status) : query time limit
> * color activity view
> green OK, orange running but query time past a configurable limit,
> blue idle, red waiting for a lock
> * menu view : item to (dis)allow color coding
>
> * select a backend process and display just the locks it's holding, and
> the one it's waiting on
>
> * enable change of connection server
>
> * add filter and sort for each report
>
> * Add a dockable toolbar to enable changing connection server, timer
> slider, filter and sort options.
>
> * Add graph reports for different statistics views, something like
> the Gnome System Monitor but specific to PostgreSQL (transaction
> rate, read/hit ratio, number of connections, bgwriter stats come to
> mind)
>
> Comments?

What is your timetable for this lot? I'm expecting us to freeze within
a few weeks. Tom wants us to get PG more or less ready for beta in two
(I think it'll take a little longer but...). We need to concentrate on
getting the changes in and complete one or two at a time until we run
out of time I guess.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com