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

Re: Is there a reason _not_ to vacuum continuously?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Matt Clark" <matt(at)ymogen(dot)net>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: Is there a reason _not_ to vacuum continuously?
Date: 2003-09-17 22:17:26
Message-ID: 200309171517.26841.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Matt,

> I understand this needs an exclusive lock on the whole table, which is
> simply not possible more than once a month, if that...  Workarounds/hack
> suggestions are more than welcome :-)

Would it be reasonable to use partial indexes on the table?

-- 
-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
                                        Josh Berkus
   Complete information technology 	josh(at)agliodbs(dot)com
    and data management solutions 	(415) 565-7293
   for law firms, small businesses 	 fax 621-2533
    and non-profit organizations. 	San Francisco


In response to

Responses

pgsql-performance by date

Next:From: Rhaoni Chiu PereiraDate: 2003-09-17 22:17:47
Subject: How to force an Index ?
Previous:From: Michael AdlerDate: 2003-09-17 20:46:00
Subject: Re: inferior SCSI performance

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