Received: from mail1.waterford.org (mail1.waterford.org [205.124.117.6]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBF27Lm61399 for ; Fri, 14 Dec 2001 21:07:27 -0500 (EST) (envelope-from olebedev@waterford.org) Received: from waterford.org ([205.124.138.93]) by mail1.waterford.org (Netscape Messaging Server 3.56) with ESMTP id 502 for ; Fri, 14 Dec 2001 18:56:41 -0700 Message-ID: <3C1AB544.9BD4D05A@waterford.org> Date: Fri, 14 Dec 2001 19:28:20 -0700 From: Oleg Lebedev X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 To: Postgres SQL Mailing List Subject: won't drop the view Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200112/152 X-Sequence-Number: 5975 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