From: | Oleg Lebedev <olebedev(at)waterford(dot)org> |
---|---|
To: | Postgres SQL Mailing List <pgsql-sql(at)postgresql(dot)org> |
Subject: | won't drop the view |
Date: | 2001-12-15 02:28:20 |
Message-ID: | 3C1AB544.9BD4D05A@waterford.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Timur V. Irmatov | 2001-12-15 05:23:52 | queries per second |
Previous Message | Jan Wieck | 2001-12-14 20:54:09 | Re: weird duplicate data problem |