News for hackers. Stuff that matters.
Re:Google Cloud Spanner is now half the cost of Amazon DynamoDB by RhodesianHunter on Wednesday October 11, 2023 @04:45PM (#37850028)
Which columnar databases are doing the above in-memory?
Re:Google Cloud Spanner is now half the cost of Amazon DynamoDB by jiggawatts on Wednesday October 11, 2023 @05:37PM (#37850566)
SQL Server supports in-memory columnstore tables. I’m not an expert but I suspect SAP HANA also.

If you squint, any database engine is “in memory” if there is more buffer than data.

Or just use a RAM disk!

Re:Google Cloud Spanner is now half the cost of Amazon DynamoDB by folmar on Wednesday October 11, 2023 @06:17PM (#37851017)
> If you squint, any database engine is “in memory” if there is more buffer than data.

That is sadly not true, I remember one lonely night debugging a MSSQL 2012 instance that was _very_ slow, and it turned out that for a simple query (one join, 100 rows in one table and 10 in the other, 100 result in total, one where clause) it forced writing the result to disk before evaluating the WHERE condition. Unable to fight the scheduler I've ended up making a ramdisk for this data.

Re:Google Cloud Spanner is now half the cost of Amazon DynamoDB by jiggawatts on Wednesday October 11, 2023 @06:36PM (#37851239)
Yes, tempdb spills can be annoying, but I believe they never occur for queries that use only in-memory tables.
Re:Google Cloud Spanner is now half the cost of Amazon DynamoDB by mianos on Wednesday October 11, 2023 @05:27PM (#37850460)
Kdb with ease, but down 500k on on licenses and the cost of people who can use it. :)