VACUUM or VACUUM FULL. Only the second actually reclaims diskspace... On Mon, Dec 20, 2004 at 03:21:51PM -0400, Jeff MacDonald wrote: > well, i did a "delete from email_log" and then a vacuum and the files > are still lingering around... > > still huge. the postmaster did die due to a diskspace issue, so i > wonder if it's still just keeping a wierd lock on those files or > something.. idea's ? > > > On Mon, 20 Dec 2004 11:01:32 -0300, Alvaro Herrera > <[EMAIL PROTECTED]> wrote: > > On Mon, Dec 20, 2004 at 09:57:35AM -0400, Jeff MacDonald wrote: > > > > > # select relname,relfilenode,relpages from pg_class where relfilenode > > > = 13312279; > > > relname | relfilenode | relpages > > > -----------+-------------+---------- > > > email_log | 13312279 | 36821 > > > > > > It just so happens that email_log has around 700,000 rows, that would > > > explain the space issues. > > > > > > I do know that email_log is 100% deleteable, so I'll proceed with hosing > > > that. > > > > > > Does all this sound reasonable ? > > > > Certainly. > > > > -- > > Alvaro Herrera (<[EMAIL PROTECTED]>) > > "Para tener más hay que desear menos" > > > > > -- > Jeff MacDonald > http://www.halifaxbudolife.ca > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster
-- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
pgp3Phv45mOZo.pgp
Description: PGP signature
