News for hackers. Stuff that matters.
Re:Migrating a 40TB SQL Server Database by hansitomani on Thursday July 30, 2020 @12:32PM (#24000105)
Wow.

I really wana know if they even compress the log data in there database.

40 TB of logs in a postgresql, like that can't be efficient?

I would probably just have a scaling blob store and would store it away. That has to be much faster, simpler and cheaper.

Re:Migrating a 40TB SQL Server Database by greggyb on Thursday July 30, 2020 @07:13PM (#24003828)
They mentioned in the article that they are using SQL Servers clustered columnstore index. This is a poor name, as it's more than just an index. CCI in SQL Server is an on-disk storage format that is a highly compressed columnstore.