Ask HN: What could a modern database do that PostgreSQL and MySQL can't

Re:Ask HN: What could a modern database do that PostgreSQL a... by Aeolun on Sunday September 05, 2021 @08:01PM (#28428951)

To be fair, while I kind of agree the system should be able to handle it regardless, 10,000s of tables sounds outside the realm of 99.99% of all use cases.

[ Parent | on HN ]

Re:Ask HN: What could a modern database do that PostgreSQL a... by CydeWeys on Sunday September 05, 2021 @08:35PM (#28429124)

You might be surprised to learn how common the "store the results of the user's query into a temporary table" pattern is.

[ Parent | on HN ]

Re:Ask HN: What could a modern database do that PostgreSQL a... by vvern on Sunday September 05, 2021 @09:35PM (#28429401)

Temporary tables in cockroach exist, but the implementation was done largely to fulfill compatibility rather than for serious use.

The implementation effectively just creates real tables that get cleaned up; they have all the same durability and distributed state despite not being accessible outside of the current session.

Getting something done here turned out to be a big deal in order to get ORM and driver tests to run, which is extremely high value.

A better implementation would just store the data locally and not involve any of the distributed infrastructure. If we did that, then temp tables wouldn't run into the other schema scalability bottlenecks I'm raising above.

[ Parent | on HN ]

Re:Ask HN: What could a modern database do that PostgreSQL a... by aidenn0 on Monday September 06, 2021 @01:55AM (#28430796)

Thanks for all of that information in those 2 posts.

[ Parent | on HN ]