From: Chris Ruprecht <chrup999@yahoo.com>
To: Oleg Lebedev <olebedev@waterford.org>
Cc: Postgres SQL Mailing List <pgsql-sql@postgresql.org>
Subject: Re: won't drop the view
Date: Sat, 15 Dec 2001 17:20:08 -0600
Message-ID: <p05101001b84189b9a14b@[192.168.0.6]> (raw)
In-Reply-To: <3C1AB544.9BD4D05A@waterford.org>
References: <3C1AB544.9BD4D05A@waterford.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: chrup999@yahoo.com, olebedev@waterford.org
Subject: Re: won't drop the view
In-Reply-To: <p05101001b84189b9a14b@[192.168.0.6]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox