25 Interesting Features of PostgreSQL 12
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 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.
Speaker at: postgresconf 2019 PerconaLive 2019 pgconf.Eu 2019
No video of the event yet, sorry!
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.
- 40 min
- PGConf India, 2020
- Database Administration