PDA

View Full Version : analyze system catalogs?

bb5508
09-24-02, 13:05
vacuum analyze does the system catalogs as well as database tables. is this good, bad or OK?
eperich
09-25-02, 05:01
Did the system crah when you run vacuum analyze?

Then it's ok.

Did the postgres server run faster?

Then it's good.

I don't know if it's good or bad.

I didn't have any troubles with that.

But If you use vacuum you schould use sometimes a "FULL" vacuum. Cause this makes the really big cleanup :-)
MaleMan
10-11-02, 01:12
how often you do vacuum in your server? my current setup is weekly, FULL vacuum.

eperich, can you give some better way to do this i mean, how often you do vacuum in a week or maybe a simple vacuum will do twice a week. ;) any ideas?

<-- by the way, our system is used by a certain manufacturing raw materials in/out and some other processes so we expect much entries and deletion of data. -->
eperich
10-11-02, 04:18
depends on the database activity
I have a website with 250.000 hits a day with inserts updates deletes 24 hozurs Live system

I run vacuum every night at 4 am.

But there are no strategies
the only strategy is. Run vacuum at times the database is not heavyliy in use
MaleMan
10-13-02, 21:45
i mean vacuum FULL everyday? i sometimes noticed that there are some fixing stuff in the log files... is it safe to run FULL vacuum everyday, or an ordinary vacuum will do.
eperich
10-14-02, 06:23
make It like some backup strategies
6 days normal vacuum and on the weekend a full vacuum
I think thats the best way
MaleMan
10-14-02, 21:04
:D thanks for the suggestion!