0
votes
1answer
172 views

Why is autovacuum using so much IO when running on a partition's master table after upgrading PosgreSQL from 8.4 to 9.1?

We have an application where we are collecting timestamp-based data. Since a month of data goes over 30M rows (and growing each month), we decided to partition the data on an year-and-month basis. We ...
2
votes
1answer
84 views

Any particular vacuum policy to increase performance using Drupal with PostgreSQL?

I'm running Drupal 7 with PostgreSQL as a Q&A (with a lot of nodes inserts/updates and several contrib modules). Do you, dba admins, recommand any particular pgsql vacuum policy on particular ...
0
votes
0answers
322 views

Database fragmentation with PostgreSQL 8.1

I'v got a 220M db running under PgSQL 8.1 (upgrade not possible ATM.). If I do a reindex, the db size goes to 220 but then it starts growing over time (it shoudln't), a few megs per day. I did ...
2
votes
1answer
2k views

postgres vacuum

Ok guys, I've moved to a new company and I see they have a single PostgreSQL database here to run OpenNMS. I'm a MySQL person, not familiar at all with PostgreSQL, but I've at least learned how to ...
0
votes
2answers
465 views

Postgresql-8.4 auto vacuum is enabled to get the best performance

I want know which one is good to follow whether auto vacuum or vacuum manually. Right now we are following manually in cron jobs, but sometimes it gets struck to vaccum on particular tables. so we are ...
8
votes
1answer
6k views

Do I need to REINDEX and VACUUM a table after deleting lots of rows?

I am running a PostgreSQL database that has several tables which store logging information. This information is for reporting purposes only and gets dumped to a file and deleted from the database if ...
3
votes
1answer
647 views

DB Full Vacuum, Cluster, Analyze - in which order?

I have a huge (~150 GBytes) postgresql database whose performance has dropped during the last weeks. In order to improve performance, I intend to perform FULL VACUUM, CLUSTER and ANALYZE. In which ...
4
votes
3answers
3k views

How do I know if the autovacuumer in postgres 8.3 is actually working?

I have a couple of postgres 8.3 databases, and they are showing symptoms of lack of vacuuming. I've checked the config, and they are in the default state of having the autovacummer turned on. ...