PgAdmin III 1.12 crazy memory usage
От | Thom Brown |
---|---|
Тема | PgAdmin III 1.12 crazy memory usage |
Дата | |
Msg-id | AANLkTinOvhkSTEjV0TBrxRT+PSfsNJkzMx_9wKvJKPV8@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: PgAdmin III 1.12 crazy memory usage
|
Список | pgadmin-support |
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
Вложения
В списке pgadmin-support по дате отправления: