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
