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


1 Bermuda: The Crossroads of the Atlantic 51:57
Benchmarking
Manage episode 355021834 series 3369151
Nikolay and Michael discuss benchmarking — reasons to do it, and some approaches, tools, and resources that can help.
Here are links to a few things we mentioned:
- Towards Millions TPS (blog post by Alexander Korotkov)
- Episode on testing
- Episode on buffers
- pgbench
- sysbench
- Improving Postgres Connection Scalability (blog post by Andres Freund)
- pgreplay
- pgreplay-go
- JMeter
- pg_qualstats
- pg_query
- Database experimenting/benchmarking (talk by Nikolay, 2018)
- Database testing (talk by Nikolay at PGCon, 2022)
- Systems Performance (Brendan Gregg’s book, chapter 12)
- fio
- Netdata
- Subtransactions Considered Harmful (blog post by Nikolay including Netdata exports)
- WAL compression benchmarks (by Vitaly from Postgres.ai)
- Dumping/restoring a 1 TiB database benchmarks (by Vitaly from Postgres.ai)
- PostgreSQL on EXT3/4, XFS, BTRFS and ZFS (talk slides from Tomas Vondra)
- Insert benchmark on ARM and x86 cloud servers (blog post by Mark Callaghan)
------------------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our 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 amazing artwork
146 פרקים
Manage episode 355021834 series 3369151
Nikolay and Michael discuss benchmarking — reasons to do it, and some approaches, tools, and resources that can help.
Here are links to a few things we mentioned:
- Towards Millions TPS (blog post by Alexander Korotkov)
- Episode on testing
- Episode on buffers
- pgbench
- sysbench
- Improving Postgres Connection Scalability (blog post by Andres Freund)
- pgreplay
- pgreplay-go
- JMeter
- pg_qualstats
- pg_query
- Database experimenting/benchmarking (talk by Nikolay, 2018)
- Database testing (talk by Nikolay at PGCon, 2022)
- Systems Performance (Brendan Gregg’s book, chapter 12)
- fio
- Netdata
- Subtransactions Considered Harmful (blog post by Nikolay including Netdata exports)
- WAL compression benchmarks (by Vitaly from Postgres.ai)
- Dumping/restoring a 1 TiB database benchmarks (by Vitaly from Postgres.ai)
- PostgreSQL on EXT3/4, XFS, BTRFS and ZFS (talk slides from Tomas Vondra)
- Insert benchmark on ARM and x86 cloud servers (blog post by Mark Callaghan)
------------------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our 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 amazing artwork
146 פרקים
כל הפרקים
×

1 pg_stat_statements track_planning 37:55




1 Getting started with benchmarking 56:32


ברוכים הבאים אל Player FM!
Player FM סורק את האינטרנט עבור פודקאסטים באיכות גבוהה בשבילכם כדי שתהנו מהם כרגע. זה יישום הפודקאסט הטוב ביותר והוא עובד על אנדרואיד, iPhone ואינטרנט. הירשמו לסנכרון מנויים במכשירים שונים.