powered by Jive Software

Why is my PostgreSQL database SO BIG!

I have open fire installed on centos5 (Redhat variant) and use PGSQL for database when I look at the database is says that is it more than .5 Gig’s I only have 7-10 Clients on this system and there is verry little traffic…Why is the databse SO BIG…

What size is everyones database?

I just think the 530MB SQL database is a bit insane for a low volume system…

Thanks in advance

B

Bret,

Have you vacuumed the database?

daryl

Thanks for that I didn’t know that it would get that out of hand…

I ran vac anal and then full…

Now database is at 23MB…From 526MB…

One last question…How do you turn on automatic vac. ?

B

Hi,

RHEL5 still uses postgres dated back 8.1 , which does not have auto vacuum by default. I would suggest running vacuumdb from cron every day or so. Its the easiest to do.

daryl

Thanks again…

Is there any real advantage to me upgrading my pgsql to the latest…

I only run a small forum and 10 user openfire on this server…

Thanks

B

Nope, stick with the vendor supported release.

daryl

As a paying RHEL customer I’d open at least a CASE, so they see that users have problems with the current database version. So they may consider to update it to a new version for RHEL6.

LG

That would be fine…But I run centos5 like I stated int he first E-mail (Redhat Variant) It is RHEL5 without the branding from Redhat…

Thank for the suggestion…

B