News for hackers. Stuff that matters.
Re:ClickHouse matches PG for single-row UPDATEs and 4000 x f... by DrBenCarson on Sunday August 17, 2025 @06:33PM (#44935531)
Does “data for application” means the operational db?
Re:ClickHouse matches PG for single-row UPDATEs and 4000 x f... by brewdad on Sunday August 17, 2025 @10:08PM (#44936707)
Do you need every record you add/update to the database to be there when you try to read it later or are you ok with a best effort to save that works to some 9x.xxxxx degree but occasionally drops some things?

If it needs to be there, use a a fully transactional database.

Re:ClickHouse matches PG for single-row UPDATEs and 4000 x f... by jedberg on Monday August 18, 2025 @12:28AM (#44937421)
It could mean that, or it could mean your user database or where you store your blog comments or your customer's todo lists. Basically anything where you want to make sure all the data is still there the next time you go looking for it.