Why is it a vacuum not needed with Mysql compared to the PostgreSQL?

Robert Haas wrote on this topic.

The short version is that InnoDB uses rollback logs, more like Oracle’s design. Only the most recent version of a row is kept on the main table. It must manage log purging, an asynchronous/delayed operation with a related function to PostgreSQL’s VACUUM.

This means more writes to do on updates and makes access to old row versions quite a lot slower, but gets rid of the need for asynchronous vacuum and means you don’t have table bloat issues. Instead you can have huge rollback segments or run out of space for rollback.

So it’s a trade-off, a design with a different set of advantages and problems.

If you’re talking about MyISAM tables, then it’s totally different. PostgreSQL’s tables won’t eat your data. MyISAM will. PostgreSQL’s tables are transactional. MyISAM isn’t. A flat file doesn’t require VACUUM either, that doesn’t make it a good idea.

Leave a Comment