On Fri, 2006-03-24 at 17:43, Jim C. Nasby wrote: > > Therein lies part of the problem: enough disk space. Now that we're > seeing more and more use of PostgreSQL in data warehousing, it's > becomming less safe to assume you'll have enough disk space to fix bloat > on large tables. Plus I suspect a lot of folks wouldn't be able to > tolerate being locked out of a table for that long (of course that > applies to VACUUM FULL as well...) >
Hello Exactly this issue and that you have to make a 'full' dump/restore between major release is a big minus I hear everywhere I explain/discuss about postgres for 24/7 and big databases. It would be wonderful to see a solution to these two 'problems' in the future so postgres becomes an even better product than it is now. -- Rafael Martinez, <[EMAIL PROTECTED]> Center for Information Technology Services University of Oslo, Norway PGP Public Key: http://folk.uio.no/rafael/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
