won't drop the view
От | Oleg Lebedev |
---|---|
Тема | won't drop the view |
Дата | |
Msg-id | 3C1AB544.9BD4D05A@waterford.org обсуждение исходный текст |
Ответы |
Re: won't drop the view
Re: won't drop the view |
Список | pgsql-sql |
Hi everybody, I just vacuumed and vacuumed analyzed my database. Now, I am trying to execute a view, which was perfectly working before, but it seems to be very slow. It was sitting there for 10 mins before I cancelled it. Usually it was taking on the order of 5 secs to execute the view. I just recreated the view, but the problem still persists. Here is what EXPLAIN tells me: EXPLAIN select * from progress_report; Subquery Scan progress_report (cost=16386.56..16386.56 rows=2 width=128) -> Sort (cost=16386.56..16386.56 rows=2 width=128) -> Nested Loop (cost=16299.45..16386.55 rows=2 width=128) How can I "restore" the "before-the-vacuum" performance? thanks, Oleg
В списке pgsql-sql по дате отправления: