Thank you everybody, I decided to modify the export process to vacuum right after the export and that has done the trick to clean up the filesystem. I know it's not the best solution but I couldn't get an answer fast enough because every time I send an email to the list, I get a message saying it was stalled and I have to wait for it to be approved by the moderator. I don't know why. :|
Anyway, I'm going to take what you guys suggested and schedule the server to be upgraded in the coming months. Thanks again for all your imput, Steve. -----Original Message----- From: Scott Marlowe [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 05, 2006 4:09 PM To: Glen Parker Cc: Schwenker, Stephen; pgsql general Subject: Re: [GENERAL] HELP: Urgent, Vacuum problem On Tue, 2006-12-05 at 14:56, Glen Parker wrote: > Scott Marlowe wrote: > > On Mon, 2006-12-04 at 09:56, Schwenker, Stephen wrote: > >> I'm using version 7.4.2 on solaris. > > > > A few points: > > > > 4: Look at migrating to 8.1 or even 8.2 (due out real soon now). > > There have been a lot of advances in pg since 7.4, and the upgrade > > is pretty painless as long as the dump / restore isn't too much of a burden. > > I couldn't agree more. 8.* is light years from where 7.4 was. > Just do it, you'll be very happy you did. I recently tossed 8.1 on my workstation which runs a little reporting application here. I pointed the app from 7.4 to 8.1 and got a visit within about an hour from a user, asking if I'd done anything to my database. Worrying that I'd made some mistake and he was getting an error or something, I asked why he'd asked, and his comment was that it now seemed to be much faster. I then commenced to breath again. 8.1 is awesome. I'll be putting 8.2 on my workstation this week. yee ha! ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
