Lesser known features of PostgreSQL | Citus Con: An Event for Postgres 2022 скачать в хорошем качестве

Lesser known features of PostgreSQL | Citus Con: An Event for Postgres 2022

Video of a talk by Haki Benita at Citus Con: An Event for Postgres. Haki presents a few lesser known, but useful PostgreSQL features you may have never heard about! For example, do you know how you can get the number of inserted and update rows in an upsert? How to create reproducible random data for testing and demonstrations? Match a text against multiple patterns without complicated condition? How about using \copy with multi-line queries? All that and more Postgres database tips in this talk from the EMEA livestream at Citus Con. Haki Benita is a technical lead and DBA specializing in databases, web development, and performance tuning. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 01:56 Lesser known features from PG 10+ ⏩ 02:40 # of updated & inserted rows at upsert ⏩ 07:18 Sleeping ⏩ 09:07 Match against multiple patterns ⏩ 11:55 Generate reproducible random data ⏩ 14:26 Dollar quoting ⏩ 17:51 Prevent setting the value of an auto-generated key ⏩ 20:34 Add constraints without validating immediately ⏩ 22:49 PSQL tips ⏩ 26:26 Q&A with Haki & Claire ✅ Learn more: Watch more Citus Con talks: https://aka.ms/cituscon-playlist 📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: https://aka.ms/cituscon 📌 Let’s connect: Twitter – @CitusCon,   / cituscon   #CitusCon #PostgreSQL #Database