From: | Chris Ruprecht <chrup999(at)yahoo(dot)com> |
---|---|
To: | Oleg Lebedev <olebedev(at)waterford(dot)org> |
Cc: | Postgres SQL Mailing List <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: won't drop the view |
Date: | 2001-12-15 23:20:08 |
Message-ID: | p05101001b84189b9a14b@[192.168.0.6] |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Ruprecht | 2001-12-15 23:34:10 | Re: queries per second |
Previous Message | Josh Berkus | 2001-12-15 22:19:47 | Re: won't drop the view |