[GENERAL] Reclaiming space

2010-09-21 Thread Christopher Gorge A. Marges
s than 20G). *Christopher Gorge A. Marges* /Software Services/ /Apollo Technologies, Inc./

Re: [GENERAL] Reclaiming space

2010-09-21 Thread Christopher Gorge A. Marges
On 9/22/2010 12:16 AM, Joshua D. Drake wrote: On Tue, 2010-09-21 at 20:39 +0800, Christopher Gorge A. Marges wrote: We are using 7.4.13 and run the pg_autovacuum. Over the years, the database has grown so our maintenance plan was to "move" everything except for the last year. Sinc

Re: [GENERAL] Reclaiming space

2010-09-22 Thread Christopher Gorge A. Marges
On 9/22/2010 12:18 PM, Scott Marlowe wrote: On Tue, Sep 21, 2010 at 9:10 PM, Christopher Gorge A. Marges wrote: But how would the newer version prevent bloat and eliminate making the database unavailable while the *maintenance* goes on? The database is more than five years old, and we did