PostgreSQL 16 Released With More Performance Improvements, SIMD For x86 & Arm

[phoronix]

Phoronix: PostgreSQL 16 Released With More Performance Improvements, SIMD For x86 & Arm

PostgreSQL 16 released today as a very exciting update for this popular open-source SQL server...

https://www.phoronix.com/news/PostgreSQL-16-Released

[vegabook]

We need a first-party column store engine for Postgres so that we can do away with third party open"ish" citus and timescaledb. That's the only missing piece in what is otherwise one of the best pieces of open source technology ever created, and brilliantly, rock solidly maintained, consistently pushed forward, and to whom we owe so much. It's right up there with Linux itself.

[yoshi314]

We need a first-party column store engine for Postgres so that we can do away with third party open"ish" citus and timescaledb. That's the only missing piece in what is otherwise one of the best pieces of open source technology ever created, and brilliantly, rock solidly maintained, consistently pushed forward, and to whom we owe so much. It's right up there with Linux itself.

i bet the developers of postgresql mutter something about patches and sending them.

[stormcrow]

i bet the developers of postgresql mutter something about patches and sending them.

Or at the very least open a feature request conversation in Postgres' community mailing list.

[archkde]

… one of the best pieces of open source technology ever created, and brilliantly, rock solidly maintained, consistently pushed forward, and to whom we owe so much. It's right up there with Linux itself.

Don't forget the other great database engine here, SQLite. I'd even say that both PostgreSQL and SQLite are more rock-solid than Linux due to their more systematic focus on correctness.

[NobodyXu]

Don't forget the other great database engine here, SQLite. I'd even say that both PostgreSQL and SQLite are more rock-solid than Linux due to their more systematic focus on correctness.

That's probably true considering how many legacy code that resides in Linux kernel and how many hardware bug workaround, and how much code that "JUST WORK"s.

Also, recently Kent tried to push Bcachefs into mainline without obeying the code review process, and skip the linux-next which performs CI testing.
His code can't even compile on Linus's machine.

It's absurd how that could happen and how many people still defending Kent's behavior, they claim that since he has been working on Bcachefs for 15 years and is a smart guy, the Linux kernel should loosen the requirement for his patch to merge, which is absolutely absurd for me.

[uid313]

Probably the best database in existence.
Too bad the user space is messy with tons of different commands instead of everything collected under one command as is done by the "git" command.
Also too bad it uses their own vanity license instead of something more common.

[mcloud]

We need a first-party column store engine for Postgres so that we can do away with third party open"ish" citus and timescaledb. That's the only missing piece in what is otherwise one of the best pieces of open source technology ever created, and brilliantly, rock solidly maintained, consistently pushed forward, and to whom we owe so much. It's right up there with Linux itself.

I think being extensions allow more than one to exists and also make it easier to improve or make better ones long term. Many stuff taken for granted in postgresql are also extensions. Maybe making it easier and making the extensions run faster would be a better goal. I for one would like the core team to fix real limitations, like the 32 bit transaction ids, even if for new major database version

[archkde]

That's probably true considering how many legacy code that resides in Linux kernel and how many hardware bug workaround, and how much code that "JUST WORK"s.

Also, recently Kent tried to push Bcachefs into mainline without obeying the code review process, and skip the linux-next which performs CI testing.
His code can't even compile on Linus's machine.

It's absurd how that could happen and how many people still defending Kent's behavior, they claim that since he has been working on Bcachefs for 15 years and is a smart guy, the Linux kernel should loosen the requirement for his patch to merge, which is absolutely absurd for me.

That's not really what I meant. The bcachefs drama seems to be mostly caused by some process mismatch between Kent and the Linux developers. It's not like some random garbage (which bcachefs likely isn't to begin with) has been merged (it hasn't).

Better examples for what I mean are the frequently shipped severe regressions (some examples from the top of my head: 5.19: Intel GPU nonsense, 6.3: XFS corruption, nftables verdict map fallthrough, 6.4: userspace stack corruption). You can also see in the bcachefs thread where there is some discussion about XFS, where the fuzzer issues of the old on-disk format are mostly ignored, and the only real fix is to use the new one (which requires a reformat). Half-assed features are shipped all the time (pidfd_getfd is severely limited by pidfd shortcomings, NTFS driver is buggy and mostly abandoned). And while the Linux kernel does have a test suite, it is not nearly as comprehensive as the SQLite one.

[flanier]

I've used Timescale for a couple of years and am very happy with it. There are people working on an updated storage engine for Postgres. How likely it is that that this or any other column store engine would ever be pulled in by the Postgres core team, I don't know.

https://www.orioledata.com