Re:Harder, Better, Faster, Stronger: New Features in Postgre...
by nimbix on Friday April 24, 2009 @12:27PM
(#577709)
My experience with several 10-20GB databases shows that if you have autovacuum enabled you don't need to run vacuum full very often. We only do it once every couple of months and we're not seeing any significant table bloat, even though we're dealing with lots of updates.
Re:Harder, Better, Faster, Stronger: New Features in Postgre...
by dr_strangelove on Friday April 24, 2009 @12:24PM
(#577702)
You don't need VACUUM FULL. If you have problems with too much disk space used by your tables, increase the autovacuum frequency.
Re:Harder, Better, Faster, Stronger: New Features in Postgre...
by sachmanb on Friday April 24, 2009 @01:28PM
(#577817)
Thanks nimbix and dr_strangelove, I'm going to take that out of my backup routine, but being that I don't like to 'remember to do things' - add it to a once every three months routine.
With AutoVacuum enabled, and adding "VACUUM FULL" to the end of my nightly backup routine, I have found Postgresql to be really fast. MySQL has had some performance updates since I switched, but at the time Postgresql was performing better for me. I believe MySQL was at the first release of version 5. If there is a performance difference between Microsoft SQL and Postgresql, I'm not noticing it. I have a lot of experience with Microsoft SQL, and I can tell you that prefer Postgresql.