Presented by:

2f06ebff71823abb213c4b64a86b9557

Jobin Augustine

Percona

Jobin Augustine is a PostgreSQL expert and Open Source advocate and has more than 18 years of working experience as consultant, architect, administrator, writer, and trainer in PostgreSQL, Oracle, and other database technologies. He has always been an active participant in the Open Source communities and his main focus area is database performance and optimization. He is a contributor to various Open Source Projects and is an active blogger and loves to code in C++ and Python.

Jobin holds a Masters in Computer Applications and joined Percona in 2018 as a Senior Support Engineer. Prior to joining Percona, he worked at OpenSCG for 2 years as Architect and was part of the BigSQL core team, a complete PostgreSQL distribution offering. Previous to his work at OpenSCG, Jobin worked at Dell as Database Senior Advisor for 10 years and 5 years with TCS/CMC.

No video of the event yet, sorry!

PostgreSQL 12 made a giant leap in many of the areas of PostgreSQL which includes partitioning, query planner, Indexing and some SQL features, etc. Among all of the interesting features for developers and admins, we shall be discussing 25 of the most interesting features with some good examples and benchmarks done This talk includes: - Partitioning improvements - Indexing Improvements 3. Standby improvements - Optimizer Improvements 5. Monitoring Improvements - Security / Authentication improvements - Server Configuration configuration - General performance and optimization - New features and functionality introduced. - Client library improvements 11. deprecated/obsolete features - Improvements and changes to tools - psql, pgbench, vacuumdb, pg_ctl, pg_upgrade, pg_checksums, pg_rewind, pg_dump, pg_dumpall,pg_restore **Very small live demonstrations will be included. - This presentation will be creating enthusiasm in the audience to upgrade for PostgreSQL 12

Date:
Duration:
50 min
Room:
Conference:
Postgres Conference 2020
Language:
Track:
Ops and Administration
Difficulty:
Easy