| 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: | Whole Thread | Raw Message | 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 |