From: Tom Lane <tgl@sss.pgh.pa.us>
To: Brian McCane <bmccane@mccons.net>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: VACUUM FULL
Date: Fri, 10 May 2002 22:04:53 -0400
Message-ID: <10108.1021082693@sss.pgh.pa.us> (raw)
In-Reply-To: <20020510185436.F62674-100000@fw.mccons.net>
References: <20020510185436.F62674-100000@fw.mccons.net>
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
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-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, bmccane@mccons.net
Subject: Re: VACUUM FULL
In-Reply-To: <10108.1021082693@sss.pgh.pa.us>
* 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