Главная
Study mode:
on
1
Intro
2
Postgres 11 vs 12
3
TwoDate function
4
TwoDate example
5
oids removed
6
No ID column
7
Foreign key naming
8
Full text search languages
9
Common materialized expressions
10
Simple query
11
Performance benefits
12
Random page costs
13
Forced plan cash mode
14
Prepare a query
15
Force generic plan
16
Reindex
17
Reindex concurrently
18
Create replace aggregates
19
Postgres Progress Vacuum
20
Postgres Cluster
21
Create Index
22
System Views
23
Storage Engines
24
Index Methods
25
Command Line Tools
26
Temp Socket
27
csv
28
pgpromote
29
multivariate column statistics
Description:
Explore the new features and improvements in PostgreSQL 12 through a series of hands-on demonstrations. Dive into enhancements like the TwoDate function, oids removal, foreign key naming, full-text search languages, and common materialized expressions. Learn about performance optimizations including random page costs, forced plan cache mode, and concurrent reindexing. Discover updates to system views, storage engines, index methods, and command-line tools. Gain practical insights into PostgreSQL 12's capabilities through this comprehensive, demo-driven conference talk by Robert Treat from credativ, presented at a Linux Foundation event.

PostgreSQL 12: New Features and Improvements - All Demos Edition

Linux Foundation
Add to list