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]
