~lobsters | Bookmarks (9)

Before we discuss what VACUUM does and its implications, we need to understand how data is actually stored on disk. What happens when a tuple is inserted, updated, or deleted? Understanding this will help us understand what VACUUM does, why it’s needed, and its implications. Tuples, Page & TOAST A tuple in database ...

Greef: The world is becoming more transactional, from servers to serverless, and per second billing. You used to buy a server every three years or rent dedicated by the month, then an instance by the hour, and now every second there's a serverless transaction. In the same way from coal to clean energy, our energy so...

Tuesday, February 13, 2024 By Pierre-Étienne Meunier An underappreciated aspect of Pijul is its backend, Sanakirja, which is easy to confuse with a mere key-value store. Sanakirja does include a key-value store, but is primarily a transactional block allocator in a file. Don’t load your datastructures The best featu...