25 Interesting Features of PostgreSQL 12
PostgreSQL 12
Presented by:
Avinash Vallarapu
Avinash Vallarapu (Avi) is currently working for Percona as a PostgreSQL Support Tech Lead. Before joining Percona, he worked for OpenSCG for 2.2 years as a Database Architect and for Dell as a Tech Lead for 9.8 Years. He has a vast experience in technologies like Oracle, PostgreSQL, MySQL and MongoDB. He is an avid Python and Golang developer. He has co-authored a book on PostgreSQL : Beginning PostgreSQL on Cloud and another book on MySQL is in progress.
He spoke at various PostgreSQL Conferences in the past including -
- PGCONF India - 2017 - Bengaluru, India.
- PGCON 2018 - Ottawa, Canada.
- Percona Live - PostgreSQL Track (2018) - Frankfurt, Germany.
His areas of expertise are PostgreSQL Training, Consulting and Migrations.
Jobin Augustine
Jobin Augustine is a PostgreSQL expert and Open Source advocate and has more than 21 years of working experience as a 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, an active blogger and loves coding in C++ and Python. Jobin holds a Masters in Computer Applications and joined Percona in 2018. Previously, he worked at OpenSCG for two years as Architect and was part of the BigSQL core team. Jobin worked at Dell as Database Senior Advisor for ten years and five years with TCS/CMC.
Speaker at many conferences
PGConf India, Almost every year till 2020
postgresconf 2019
PerconaLive 2019
pgconf.Eu 2019
Download slides
PostgreSQL continued to be the DBMS of the year for 2018. An interesting fact is that there is a new release every year. So we have another new release this year, PostgreSQL 12. It is planned to be released in the third quarter of the year 2019. There are a lot of improvements in 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 them in 40 mins with some examples and benchmarks done on the PostgreSQL 12.
This talk is to introduce PostgreSQL 12 and its new features to audience. It is designed into several categories such as improvements in Partitioning, Indexing performance, Query Planner improvements, SQL improvements, Table access methods and other improvements. By the end of the talk, the audience should have a clear understanding of all the features and benchmarks.
- Date:
- 2020 February 27 - 11:45
- Duration:
- 40 min
- Room:
- Grand Victoria 1
- Conference:
- PGConf India, 2020
- Language:
- Track:
- Database Administration
- Difficulty:
- Medium
- Journey of the Query from SELECT to Result set.
- Start Time:
- 2020 February 27 11:45
- Room:
- Robusta + Arabica
- Why physical storage of your database tables might matter
- Start Time:
- 2020 February 27 11:45
- Room:
- Grand Victoria 2