Why is my PostgreSQL database SO BIG!

Openfire Openfire Support
1

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

2

Bret,

Have you vacuumed the database?

daryl

3

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

4

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

5

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

6

Nope, stick with the vendor supported release.

daryl

7

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

8

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