34 subscribers
התחל במצב לא מקוון עם האפליקציה Player FM !
פודקאסטים ששווה להאזין
בחסות


Index maintenance
Manage episode 342020260 series 3369151
Important correction from this episode: amcheck promises no false positives, not no false negatives, sorry!
Here are links to a few things we mentioned:
- pgstattuple
- pg_repack
- postgres-checkup
- Workload Analysis for GitLab.com
- Bloat Analysis (also from GitLab)
- Bloat, pg_repack, and deferred constraints (blog post by Miro)
- amcheck
- Peter Geoghegan interview (on Postgres TV)
------------------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides or by commenting on our topic ideas Google doc.
If you would like to share this episode, here's a good link (and thank you!)
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
With special thanks to:
- Jessie Draws for the elephant artwork
161 פרקים
Manage episode 342020260 series 3369151
Important correction from this episode: amcheck promises no false positives, not no false negatives, sorry!
Here are links to a few things we mentioned:
- pgstattuple
- pg_repack
- postgres-checkup
- Workload Analysis for GitLab.com
- Bloat Analysis (also from GitLab)
- Bloat, pg_repack, and deferred constraints (blog post by Miro)
- amcheck
- Peter Geoghegan interview (on Postgres TV)
------------------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides or by commenting on our topic ideas Google doc.
If you would like to share this episode, here's a good link (and thank you!)
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
With special thanks to:
- Jessie Draws for the elephant artwork
161 פרקים
כל הפרקים
×





1 MultiXact member space exhaustion 55:43








1 pg_stat_statements track_planning 37:55




1 Getting started with benchmarking 56:32








1 Logical replication common issues 38:12

1 Why isn't Postgres using my index? 35:25

1 Overhead of pg_stat_statements and pg_stat_kcache 34:07







1 pg_upgrade: the tricky and dangerous parts 25:38
















1 NULLs: the good, the bad, the ugly, and the unknown 27:10


1 Slow queries and slow transactions 26:00
ברוכים הבאים אל Player FM!
Player FM סורק את האינטרנט עבור פודקאסטים באיכות גבוהה בשבילכם כדי שתהנו מהם כרגע. זה יישום הפודקאסט הטוב ביותר והוא עובד על אנדרואיד, iPhone ואינטרנט. הירשמו לסנכרון מנויים במכשירים שונים.