Postgres Pro
Downloads
Home   >   mailing lists

Re: Is there a reason _not_ to vacuum continuously? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Is there a reason _not_ to vacuum continuously?
Date
Msg-id 200309171517.26841.josh@agliodbs.com
Whole thread Raw
In response to Re: Is there a reason _not_ to vacuum continuously?  ("Matt Clark" <matt@ymogen.net>)
List pgsql-performance
Tree view 
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@agliodbs.com
    and data management solutions     (415) 565-7293
   for law firms, small businesses      fax 621-2533
    and non-profit organizations.     San Francisco

pgsql-performance by date:

Previous
From: Rhaoni Chiu Pereira
Date:
Subject: How to force an Index ?
Next
From: Josh Berkus
Date:
Subject: Re: How to force an Index ?