I can't recreate this, so it may not be much help, but I left PgAdmin running with no query windows open at all, and eventually I noticed my PC slowing right down as memory started to swap. I've attached a screenshot to show its memory usage.
Actions I had performed earlier are attempting to select all rows from a massive table, and closed that result window a few seconds into it attempting to fetch results. I had issued a few queries in other query windows which were quite minor ones which got counts. I doubled the tablespace's random page cost for one of the connected clusters, and updated the statistics target for a column on a table, then performed a VACUUM ANALYZE. And I also attempted to restore a ~20GB custom format database into a new database, but killed the process some minutes into it as the cancel button on the restore window wasn't responding. The window then showed a status of restore failed. I then deleted that database. After all this, no more query windows, result windows, or any other PgAdmin-related windows were open except for the main application. It was presumably idle as I had no other running processes, and was left focused on a cluster node. -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935
<<attachment: pgadmin_memory.png>>
-- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
