To: Brian McCane <bmccane@mccons.net>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: VACUUM FULL 
In-reply-to: <20020510185436.F62674-100000@fw.mccons.net> 
References: <20020510185436.F62674-100000@fw.mccons.net>
Comments: In-reply-to Brian McCane <bmccane@mccons.net>
	message dated "Fri, 10 May 2002 19:18:42 -0500"
Date: Fri, 10 May 2002 22:04:53 -0400
Message-ID: <10108.1021082693@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Brian McCane <bmccane@mccons.net> writes:
> I INSERT/UPDATE/DELETE approximately 300,000 records per day, but this
> number is increasing on a daily basis as I make changes which improve the
> performance of my data gathering tools (spiders ;).  Two days ago, it had
> reached the point where a search for a 3-word term (ie. free news servers)
> took about 60 seconds.  I have just spent 48 hours running a VACUUM FULL
> on my table, and now the same search takes < 10 seconds.

I would have to assume that the change is due to a change in plan, and
not directly due to VACUUM having compacted out a small part of the
space.

Did you do VACUUM ANALYZE, or just plain VACUUM?  When was the last time
you did VACUUM (or ANALYZE) on this table?  What plan is being used now?
Do you have any idea what plan was used before?

			regards, tom lane