won't drop the view

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

Responses

Browse pgsql-sql by date

  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