PostgreSQL 11 Beta 4 Released With JIT Compilation Disabled By Default

[phoronix]

Phoronix: PostgreSQL 11 Beta 4 Released With JIT Compilation Disabled By Default

The fourth and likely last beta release of PostgreSQL 11 is now available...

http://www.phoronix.com/scan.php?page=news_item&px=PostgreSQL-11-Beta-4

[alpha_one_x86]

JIT + OpenCL is very very powerfull, 5x in some case

[uid313]

Notably absent features from the SQL standard in PostgreSQL are from section E182, F181, F812, S011, S011-01, and T321-05.

Comparison table on Wikipedia. PostgreSQL is looking really good!

https://en.wikipedia.org/wiki/SQL_compliance

The most fully featured SQL database in existence?
Has nice features such as support for stored procedures written in Python.

Doesn't seem to support the SQL/JSON standard though (even though it has support for JSON through its own implementation). Maybe Oracle is the only database implementing the SQL/JSON standard?

PostgreSQL supports most of the major features of SQL:2011. Out of 179 mandatory features required for full Core conformance, PostgreSQL conforms to at least 160. In addition, there is a long list of supported optional features. It might be worth noting that at the time of writing, no current version of any database management system claims full conformance to Core SQL:2011.

Unclear whether it support any of SQL:2016.

PostgreSQL notably lacks support for:
ISO/IEC 9075-4 Persistent Stored Modules (SQL/PSM)
ISO/IEC 9075-10 Object Language Bindings (SQL/OLB)

https://www.postgresql.org/docs/11/static/features.html

https://www.postgresql.org/docs/11/static/features-sql-standard.html

https://www.postgresql.org/docs/11/static/unsupported-features-sql-standard.html