Thanks. I have made the changes and will hopefully see some space savings soon.
Stephen Massman [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of David Schnur Sent: Tuesday, January 12, 2010 12:47 PM To: InterMapper Discussion Subject: Re: [IM-Talk] Shrink database On 1/12/2010 1:36 PM, Michael Graziano wrote: > You may also need to connect to Postgres directly and do a VACUUM FULL > after you apply the new retention policy. If I'm remembering correctly > the normal autovacuum routine won't really compact the disk file (it > assumes you'll re-fill those "dead" rows), so you need to prod it manually. > > Depending on how many rows worth of old data you're getting rid of a > dump/restore of the database may be faster than vacuuming... Yes, that's a good point. Simply changing the retention policies won't free up the space immediately. Retention policies are applied every morning at 1AM. At that point the space is freed up for re-use by the database, but still occupies the same amount of space on disk. Once a week on Sunday, IMDatabase runs a VACUUM FULL to fully free the space on disk. Both actions can be run manually from the 'Maintenance' page in the IMDataCenter web interface. From that page, you can also manually delete all data past a certain age, without having to mess around with retention policies. But, as Michael pointed out, be aware that those actions can take a few hours to run if a lot of space is being freed. David -- David Schnur Dartware, LLC http://www.dartware.com ____________________________________________________________________ List archives: http://www.mail-archive.com/intermapper-talk%40list.dartware.com/ To unsubscribe: send email to: [email protected] ____________________________________________________________________ List archives: http://www.mail-archive.com/intermapper-talk%40list.dartware.com/ To unsubscribe: send email to: [email protected]
