3 ms·
My databases in Postgresql have not exceeded approximately 10GB, so for larger databases you may want additional information. With AutoVacuum enabled, and addi
by sachmanb 17y ago
My databases in Postgresql have not exceeded approximately 10GB, so for larger databases you may want additional information.
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.
- dr_strangelove 17y agoYou don't need VACUUM FULL. If you have problems with too much disk space used by your tables, increase the autovacuum frequency.
- sachmanb 17y agoThanks 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.
- nimbix 17y agoMy 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.