Tag Archives: vacuum

PostgreSQL 對 Vacuum 效能的改善

在「No More Full-Table Vacuums」這邊提到了 PostgreSQL 在 vacuum 時效能的大幅改善,尤其是大型資料庫在 vacuum 時需要對整個表格從頭到尾掃一次以確保 transaction id 的正確性: Current releases of PostgreSQL need to read every page in the database at least once every 2 billion write transactions (less, with default settings) to verify that … Continue reading

Posted in Computer, Database, Murmuring, PostgreSQL, Software | Tagged , , , , , , , , , , | Leave a comment

真空環境下,羽毛與保齡球的自由落體

BBC 跑去 NASA 在俄亥俄州的 Space Power Facility 做實驗:「The Hammer-Feather Drop in the world’s biggest vacuum chamber」。 超大的真空環境!XD

Posted in Murmuring, Recreation, Science, Television | Tagged , , , , , , , , , , | Leave a comment