won't drop the view

Поиск
Список
Период
Сортировка
От Oleg Lebedev
Тема won't drop the view
Дата
Msg-id 3C1AB544.9BD4D05A@waterford.org
обсуждение исходный текст
Ответы Re: won't drop the view  ("Josh Berkus" <josh@agliodbs.com>)
Re: won't drop the view  (Chris Ruprecht <chrup999@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: weird duplicate data problem
Следующее
От: "Timur V. Irmatov"
Дата:
Сообщение: queries per second