On Jan 12, 2010, at 12:57 PM, David Schnur wrote:
Hi Stephen,
Is there any way to shrink/compact the database of Intermapper.
The size of the database can be reduced by using more restrictive
data retention policies. You'll want to make sure that the server-
wide (in Server Settings, on the Database Server pane) and map-wide
(in Map Settings) retention policies are set to something other than
'Forever'.
Also, if your IM server was runing IM 4.6 or earlier at some point,
then any datasets created back then were given a policy of
'IM46Charts' when you upgraded. By default, IM46Charts keeps data
forever, to match the behavior of 4.6 and earlier. You can use the
'Policies' page in the IM DataCenter web interface to edit
IM46Charts, so it keeps raw data for only a few days, or whatever
matches how you intend to use it.
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...
-MG
____________________________________________________________________
List archives:
http://www.mail-archive.com/intermapper-talk%40list.dartware.com/
To unsubscribe: send email to: [email protected]
