rtpdesign file's size

smgomes

Hi,

I'm using PostgreSQL in my application, and my database's backup have 600Kb...recently I create some templates with charts and backup size greatly increased! The rptdesign have a line chart and the size's file it's 350Kb! Is this normal? Is there any way to reduce the size? Thanks

Best regards,
S?rgio

Tubal

Are you saying your postgresql db is growing when you run your reports?<br />
<br />
It's normal for your db to grow as you access and update the data. This will happen with with any access, and isn't related to BIRT or your reports. <br />
<br />
My .rptdesign files are anywhere from 30kb up to 5MB. Just depends on what is in your report.<br />
<br />
As far as your postgresql db, as you access and update it, the tables retain space even if you've deleted the data. You'll want to vacuum your tables occasionally to get rid of this empty space.<br />
<br />
<a class='bbc_url' href='http://www.postgresql.org/docs/9.1/static/sql-vacuum.html'>http://www.postgresql.org/docs/9.1/static/sql-vacuum.html</a&gt;