We can't find the internet
Attempting to reconnect
Something went wrong!
Hang in there while we get back on track
A Look at the Elephant's Trunk: PostgreSQL 11 - Magnus Hagander
Here is the meta description: "Join Magnus Hagander as he takes a closer look at the features and improvements in PostgreSQL 11, including declarative partitioning, parallel append, stored procedures, and more."
- PostgreSQL 11 is not yet complete, with many features still being worked on.
- Declarative partitioning allows for more efficient management of large tables.
- PostgreSQL 11 adds support for parallel append, which can improve performance.
-
The
set statisticscommand now supports expression indexes. -
The
pgprewarmplugin can be used to preload data into the cache. - PostgreSQL 11 adds support for stored procedures, which can improve performance and security.
-
The
scramauthentication mechanism is now more secure and can be used with channel binding. - PostgreSQL 11 adds support for array domains, which can be used to create arrays of domains.
-
The
rangedata type has been improved, with support for range between queries. - PostgreSQL 11 adds support for JSON and JSONB data types.
-
The
on conflictclause has been improved, with support for serializable isolation level and parallel query. - PostgreSQL 11 adds support for data level checksums, which can be used to verify data integrity.
-
The
pg_stat_statementsview has been improved, with support for expression indexes. - PostgreSQL 11 adds support for stored functions, which can be used to improve performance and security.
-
The
scramauthentication mechanism is now more secure and can be used with channel binding. - PostgreSQL 11 adds support for domain-based data types, which can be used to create more complex data types.
-
The
rangedata type has been improved, with support for range between queries. - PostgreSQL 11 adds support for JSON and JSONB data types.
-
The
on conflictclause has been improved, with support for serializable isolation level and parallel query. - PostgreSQL 11 adds support for data level checksums, which can be used to verify data integrity.
-
The
pg_stat_statementsview has been improved, with support for expression indexes. - PostgreSQL 11 adds support for stored functions, which can be used to improve performance and security.