Received: from smtp014.mail.yahoo.com (smtp014.mail.yahoo.com [216.136.173.58]) by postgresql.org (8.11.3/8.11.4) with SMTP id fBFNK9m50341 for ; Sat, 15 Dec 2001 18:20:09 -0500 (EST) (envelope-from chrup999@yahoo.com) Received: from chill-025.dfw.tx.bbnow.net (HELO ?192.168.0.6?) (24.219.2.25) by smtp.mail.vip.sc5.yahoo.com with SMTP; 15 Dec 2001 23:20:11 -0000 Mime-Version: 1.0 X-Sender: chrup999@pop.mail.yahoo.com Message-Id: In-Reply-To: <3C1AB544.9BD4D05A@waterford.org> References: <3C1AB544.9BD4D05A@waterford.org> Date: Sat, 15 Dec 2001 17:20:08 -0600 To: Oleg Lebedev From: Chris Ruprecht Subject: Re: won't drop the view Cc: Postgres SQL Mailing List Content-Type: text/plain; charset="iso-8859-1" ; format="flowed" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id fBFNdAn50959 X-Archive-Number: 200112/157 X-Sequence-Number: 5980 Hi Oleg, At 19:28 -0700 12/14/2001, Oleg Lebedev wrote: >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, I don't know much about the internal workings about 'vacuum'. My guess is that there is something wrong with one of the indexes in your db somewhere. I would try and rebuild them - starting with the ones involved in the view. You might have to drop and re-create them - as well as the view. Good luck, Chris -- Chris Ruprecht Network grunt and bit pusher extraordinaíre _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com