Re: [GENERAL] Need help in reclaiming disk space by deleting the selected records

2012-09-14 Thread Steve Crawford
On 09/14/2012 05:35 AM, Andres Freund wrote: Hi, On Friday, September 14, 2012 01:29:59 AM Steve Crawford wrote: 2. CLUSTER is typically way faster than VACUUM FULL and rebuilds the indexes as well but it temporarily requires sufficient disk-space to write out a copy of the table being clustere

Re: [GENERAL] Need help in reclaiming disk space by deleting the selected records

2012-09-14 Thread Andres Freund
Hi, On Friday, September 14, 2012 01:29:59 AM Steve Crawford wrote: > 2. CLUSTER is typically way faster than VACUUM FULL and rebuilds the > indexes as well but it temporarily requires sufficient disk-space to > write out a copy of the table being clustered. Thats not the case anymore since 9.0

Re: [GENERAL] Need help in reclaiming disk space by deleting the selected records

2012-09-13 Thread Steve Crawford
On 09/13/2012 06:33 AM, Yelai, Ramkumar IN BLR STS wrote: Hi All, I am a beginner in Postgresql and Databases. I have a requirement that reclaiming disk space by deleting the rows in a selected time span. I went through the documents and articles to know how to get the table size (_http://wiki

[GENERAL] Need help in reclaiming disk space by deleting the selected records

2012-09-13 Thread Yelai, Ramkumar IN BLR STS
Hi All, I am a beginner in Postgresql and Databases. I have a requirement that reclaiming disk space by deleting the rows in a selected time span. I went through the documents and articles to know how to get the table size (http://wiki.postgresql.org/wiki/Disk_Usage) But before let the user d