The birth of the open source enterprise stack
Posted Jun 29, 2006 16:08 UTC (Thu) by dskoll
In reply to: The birth of the open source enterprise stack
Parent article: The birth of the open source enterprise stack
If I were to use PostgreSQL for this load, I would end up with a huge, ever-growing file, because updates are handled like inserts.
Correct, sort-of. VACUUM would reclaim the space.
I would likely have unbounded index growth, as VACUUM does not reclaim index space
This is no longer true. Since 8.0 (and possibly since 7.4), VACUUM reclaims index space.
to post comments)