Re: [GENERAL] diskspace usage recovered on db rebuild

2005-04-04 Thread David Link
Thank you Scott and Lonni for your replies ... On Fri, 2005-04-01 at 11:21, David Link wrote: I have a question regarding filesystem disk space usage. We have a production database containing 5 years of sales data. Linux 2.6.5; Postgresq 7.4.7. VACUUM ANALZYE the entire database everynight (abou

Re: [GENERAL] diskspace usage recovered on db rebuild

2005-04-01 Thread Scott Marlowe
On Fri, 2005-04-01 at 11:21, David Link wrote: > Greetings worthymen. > > I have a question regarding filesystem disk space usage. > > We have a production database containing 5 years of sales data. > Linux 2.6.5; Postgresq 7.4.7. VACUUM ANALZYE the entire database > everynight (about 40min).

Re: [GENERAL] diskspace usage recovered on db rebuild

2005-04-01 Thread Lonni J Friedman
On Apr 1, 2005 9:21 AM, David Link <[EMAIL PROTECTED]> wrote: > Greetings worthymen. > > I have a question regarding filesystem disk space usage. > > We have a production database containing 5 years of sales data. > Linux 2.6.5; Postgresq 7.4.7. VACUUM ANALZYE the entire database > everynight (a

[GENERAL] diskspace usage recovered on db rebuild

2005-04-01 Thread David Link
Greetings worthymen. I have a question regarding filesystem disk space usage. We have a production database containing 5 years of sales data. Linux 2.6.5; Postgresq 7.4.7. VACUUM ANALZYE the entire database everynight (about 40min). It's size, @SUM(pg_class.relpages) * 8192K, is ... About 66 G