Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] How to know when to vacuum

From: Chris Johnson <cmj(at)inline-design(dot)com>
To: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] How to know when to vacuum
Date: 1998-07-28 14:37:18
Message-ID: Pine.LNX.4.00.9807281026360.201-100000@boreus.bedfo.ma.tiac.net (view raw or flat)
Thread:
Lists: pgsql-general
OK, so there's been quite a bit of traffic about vacuuming databases as
well as more than one suggestion on how to do it.  But there really hasn't
been an answer to the question of how to know when to vacuum.

I now vacuum the databases every night, but this seems somewhat
inefficient... I know that some of the more active databases could use
some extra vacuuming, but which ones? how often?  If there is a way to ask
postgres whether a specific database could use a vacuuming I will be happy
to write something to automate it, but I see no way to do so.

Anyone have any suggestions?

Thanks,
Chris



In response to

Responses

pgsql-general by date

Next:From: The Hermit HackerDate: 1998-07-28 14:59:05
Subject: Re: [GENERAL] How to know when to vacuum
Previous:From: James Olin OdenDate: 1998-07-28 12:35:35
Subject: Re: [GENERAL] Postgres vs commercial products

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group