filmov
tv
Hacking On Postgres is Hard! | Scaling Postgres 315
Показать описание
To get the show notes as well as get notified of new episodes, visit:
In this episode of Scaling Postgres, we discuss how hacking on Postgres is hard, a notifier pattern for using Listen/Notify, using histograms for metrics and saturated arithmetic.
Want to learn more about Postgres performance?
Timestamps:
00:00 - Intro
00:25 - Hacking on PostgreSQL is Really Hard
05:23 - The Notifier Pattern for Applications That Use Postgres
08:06 - Histograms worked
09:21 - Saturation Arithmetic with a PostgreSQL Extension
10:29 - Postgres Planner Quirks: The impact of ORDER BY + LIMIT on index usage
12:32 - LIMIT vs Performance
13:23 - What's new in pgvector v0.7.0
14:39 - (Bi) Temporal Tables, PostgreSQL and SQL Standard
16:58 - How not to change PostgreSQL column type
18:02 - CURSOR_TUPLE_FRACTION AND THE POSTGRESSQL JDBC DRIVER
19:05 - Outro
#postgres #postgresql
In this episode of Scaling Postgres, we discuss how hacking on Postgres is hard, a notifier pattern for using Listen/Notify, using histograms for metrics and saturated arithmetic.
Want to learn more about Postgres performance?
Timestamps:
00:00 - Intro
00:25 - Hacking on PostgreSQL is Really Hard
05:23 - The Notifier Pattern for Applications That Use Postgres
08:06 - Histograms worked
09:21 - Saturation Arithmetic with a PostgreSQL Extension
10:29 - Postgres Planner Quirks: The impact of ORDER BY + LIMIT on index usage
12:32 - LIMIT vs Performance
13:23 - What's new in pgvector v0.7.0
14:39 - (Bi) Temporal Tables, PostgreSQL and SQL Standard
16:58 - How not to change PostgreSQL column type
18:02 - CURSOR_TUPLE_FRACTION AND THE POSTGRESSQL JDBC DRIVER
19:05 - Outro
#postgres #postgresql
0:19:32
Hacking On Postgres is Hard! | Scaling Postgres 315
0:36:56
How Figma Hacked Postgres Into Scalability
0:08:12
5 Secrets for making PostgreSQL run BLAZING FAST. How to improve database performance.
0:42:36
Hacking with Postgres 11 - pg_threads
0:33:06
Hacking the Query Planner, Again - Richard Guo: PGCon 2020
0:02:11
Databases: Postgresql query history hacking
0:01:39
Understanding the Risks: Why Your AWS RDS Postgres DB Might Get Hacked
0:01:12
Your Manager is Right
0:39:10
Pwning Cloud Vendors with Untraditional PostgreSQL Vulnerabilities
0:48:43
Postgres Hacking with Andrey, Kirk, and Nikolay: include ANALYZE steps to all dumps - part 2/2
0:10:20
Dev Deletes Entire Production Database, Chaos Ensues
0:19:51
Scaling 7M+ Postgres Tables! by Kailash Nadh CTO @zerodha
0:15:27
IT Security Postgres vulnerabilities Metasploitable 2
0:11:07
Vulnerable column not showing new bypass technique (Detecting PostgreSQL Injection)
0:52:40
Breaking PostgreSQL at Scale
0:07:39
The surprising logic of the Postgres work_mem setting, and how to tune it
0:09:38
Sorting in Postgres 15 is 371% faster in certain cases
0:02:23
SQL Explained in 100 Seconds
0:00:11
How IITians study😂 | IIT Delhi
0:43:27
Upgrades | Postgres.FM 037 | #PostgreSQL #Postgres podcast
0:05:57
Secret To Optimizing SQL Queries - Understand The SQL Execution Order
0:01:00
Data Analysis SQL Interview Questions | Running SUM | Who Hit the Sales Target First
0:46:17
Lessons Learned the Hard Way Postgres in Production at GoCardless
0:11:33
Postgres Goes Parquet | Scaling Postgres 339
Комментарии