REFRESH MATERIALIZED VIEW blocks pgAdmin III login
От | Albe Laurenz |
---|---|
Тема | REFRESH MATERIALIZED VIEW blocks pgAdmin III login |
Дата | |
Msg-id | A737B7A37273E048B164557ADEF4A58B3659CA46@ntex2010i.host.magwien.gv.at обсуждение исходный текст |
Ответы |
Re: REFRESH MATERIALIZED VIEW blocks pgAdmin III login
|
Список | pgadmin-support |
If you try to connect to a database while REFRESH MATERIALIZE VIEW for a materialized view in the database is in progress, the interface will "hang" (the window remains blank and does not react to the mouse). This is probably caused by the ACCESS EXCLUSIVE locks that are held during REFRESH MATERIALIZED VIEW. When the command finishes, pgAdmin III continues working as usual. I'd say that this is a bug, because it is not unusual for REFRESH MATERIALIZED VIEW to take a very long time, and in that time pgAdmin III is not working. I tried with versions 1.20.0 and 1.18.1. Here is a sample materialized view useful for testing: CREATE MATERIALIZED VIEW x AS SELECT CASE WHEN pg_sleep(1) ISNULL THEN i ELSE 0 END FROM generate_series(1, 100000) i WITH NO DATA; Enter "REFRESH MATERIALIZED VIEW x" and try to connect with pgAdmin III! Yours, Laurenz Albe
В списке pgadmin-support по дате отправления: