PGCon Online, Performance Tips, Tracking Counts, Essential Monitoring | Scaling Postgres 115

Scaling Postgres

Player FM - Internet Radio Done Right

75 subscribers

הוסף לפני seven שנים

محتوای ارائه شده توسط creston.jamison@rubytreesoftware.com (Ruby Tree Software Inc) and Creston Jamison. تمام محتوای پادکست شامل قسمت‌ها، گرافیک‌ها و توضیحات پادکست مستقیماً توسط creston.jamison@rubytreesoftware.com (Ruby Tree Software Inc) and Creston Jamison یا شریک پلتفرم پادکست آن‌ها آپلود و ارائه می‌شوند. اگر فکر می‌کنید شخصی بدون اجازه شما از اثر دارای حق نسخه‌برداری شما استفاده می‌کند، می‌توانید روندی که در اینجا شرح داده شده است را دنبال کنید.https://fa.player.fm/legal

The So What from BCG

1
Not All Growth Is Good—Here's How to Get It Right 20:09

17 روز پیش20:09

پخش در آینده

لیست ها

پسندیدن

دوست داشته شد

20:09

Justin Manly, BCG’s lead on growth and innovation, explains how businesses can choose the right growth strategy given their aspirations and position in the market. Whether a company is gaining or losing share, in a booming or sluggish industry, profitable growth depends on knowing your starting point. Learn More: Justin Manly: https://on.bcg.com/4kGYyPH BCG’s Latest Thinking on Growth and Innovation Analytics: https://on.bcg.com/4kjTEIB BCG’s Latest Thinking on Corporate Finance and Strategy: https://on.bcg.com/3ZeAMlX Your Growth Strategy Depends on Your Starting Point: https://on.bcg.com/43YpzZm The Vitality Code: How Growth Leaders Master Strategy, Technology, People, and Culture: https://on.bcg.com/4dMKjH1 This podcast uses the following third-party services for analysis: Podtrac - https://analytics.podtrac.com/privacy-policy-gdrp…

۵ سال پیش 12:50

MP3•خانه قسمت

In this episode of Scaling Postgres, we discuss PGCon going online, application performance tips, ways to track counts and essential areas to monitor.

To get the show notes as well as get notified of new episodes, visit:

https://www.scalingpostgres.com/episodes/115-pgcon-online-performance-tips-tracking-counts-essential-monitoring/

539 قسمت

#Ruby Tree Software Inc #Creston Jamison #Web Development #Tech #Software Development

PGCon Online, Performance Tips, Tracking Counts, Essential Monitoring | Scaling Postgres 115

Scaling Postgres

75 subscribers

published ۵ سال پیش

اشتراک گذاری

MP3•خانه قسمت

In this episode of Scaling Postgres, we discuss PGCon going online, application performance tips, ways to track counts and essential areas to monitor.

To get the show notes as well as get notified of new episodes, visit:

https://www.scalingpostgres.com/episodes/115-pgcon-online-performance-tips-tracking-counts-essential-monitoring/

539 قسمت

#Ruby Tree Software Inc #Creston Jamison #Web Development #Tech #Software Development

همه قسمت ها

1
New Scale Out Options | Scaling Postgres 370 14:51

۵ روز پیش14:51

14:51

In this episode of Scaling Postgres, we discuss the start of Multigres which is a Vitess for Postgres, pgactive going open source, getting started with logical replication and a summer of upgrades. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/370-new-scale-out-options/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

1
Move Off Of RDS? | Scaling Postgres 369 18:01

12 روز پیش18:01

18:01

In this episode of Scaling Postgres, we discuss why and how you could move off of AWS RDS, Snowflake acquires Crunchy Data, reducing your SQL queries and a novel way to migrate to partition tables. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/369-move-off-of-rds/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

1
4 Times Faster UUID Primary Keys | Scaling Postgres 368 19:10

19 روز پیش19:10

19:10

In this episode of Scaling Postgres, we discuss the benefits of using time-based UUIDv7 vs UUIDv4 for primary keys, how OpenAI uses Postgres, handling locks and methods to migrate to partition tables with low downtime. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/368-4-times-faster-uuid-primary-keys/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

1
How Often Does That Query Run? | Scaling Postgres 367 13:10

26 روز پیش13:10

13:10

In this episode of Scaling Postgres, we discuss a Postgres VS code extension, service definition files, undead tuples and the benefits of finding out how often a query is run. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/367-how-often-does-that-query-run/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

1
20,000 Times Faster Order By Limit | Scaling Postgres 366 14:46

۵ weeks پیش14:46

14:46

In this episode of Scaling Postgres, we discuss a top ten dangerous Postgres issues list, importing and exporting statistics, more Postgres 18 beta features and a 20,000 times faster query by fixing an order by limit issue. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/366-20k-faster-order-by-limit/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

1
Here Comes Async I/O! | Scaling Postgres 365 20:01

۶ weeks پیش20:01

20:01

In this episode of Scaling Postgres, we discuss async I/O introduced in PG 18 Beta 1, new Postgres releases, PgDog performance and innovative ways to optimize queries. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/365-here-comes-async-io/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

1
Scaling For High Volume | Scaling Postgres 364 20:39

۷ weeks پیش20:39

20:39

In this episode of Scaling Postgres, we discuss scaling for high volume, why workflows should be Postgres rows, a planner gotcha and ways to resolve planner issues. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/364-scaling-for-high-volume/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

1
Top Ten Postgres Dos & Don'ts | Scaling Postgres 363 13:32

۸ weeks پیش13:32

13:32

In this episode of Scaling Postgres, we discuss a top ten dos and don't for Postgres, understanding statistics and extended statistics, aligning columns to reduce padding and how to handle disaster recovery. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/363-top-ten-postgres-dos-and-donts/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

1
Optimizing For Time-Series Data | Scaling Postgres 362 12:22

۹ weeks پیش12:22

12:22

In this episode, we discuss optimizing for time-series data, indexing vectors, Postgres APT extension packaging and how to optimize queries involving low cardinality data columns. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/362-optimizing-for-time-series-data/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

1
A Roadmap To Scaling Postgres | Scaling Postgres 361 17:28

10 weeks پیش17:28

17:28

In this episode of Scaling Postgres, we discuss a roadmap to scaling Postgres, life altering Postgres patterns, making Postgres better with OrioleDB, performance cliffs and efficient use of foreign keys. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/361-roadmap-to-scaling-postgres/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

1
Handle One Million Connections? | Scaling Postgres 360 16:17

11 weeks پیش16:17

16:17

In this episode of Scaling Postgres, we discuss how a new tool pgDog might allow one million client connections to Postgres, novel use cases for pgvector other than semantic search, don't expose port 5432 and Postgres on Kubernetes. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/360-handle-one-million-connections/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

1
Trillions of Rows & Metrics | Scaling Postgres 359 18:27

12 weeks پیش18:27

18:27

In this episode of Scaling Postgres, we talk about indexes being added to Timescale's column store, processing 1 trillion metrics in Timescale, processing 1 trillion rows in Citus and partitions for deletion use cases. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/359-trillions-of-rows-and-metrics/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

1
Postgres Conference 2025 | Scaling Postgres 358 23:37

13 weeks پیش23:37

23:37

In this episode of Scaling Postgres, I discuss my experience attending Postgres Conference 2025 and cover some of the highlights of the conference. Interestingly, at least from my perspective, the most well attended talks seemed to cover pg_vector, analytics involving duckdb and partitioning. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/358-postgres-conference-2025/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

1 year پیش15:12

15:12

Scaling Postgres

1
Scale Through Sharding | Scaling Postgres 308 18:15

1 year پیش18:15

18:15

In this episode of Scaling Postgres, we discuss high availability's future, a custom sharding solution by Figma, sharding pg_vector queries, and PG17 logical replication failover. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/308-scale-through-sharding/…

Scaling Postgres

1
Collation Conundrum | Scaling Postgres 307 14:22

1 year پیش14:22

14:22

In this episode of Scaling Postgres, we discuss whether we should be using bytewise or linguistic ordering by default, how to transform data in Postgres, benefits of a transaction_timeout and how to enforce join order. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/307-collation-conundrum/…

Scaling Postgres

1
Scalability Limits From SLRU & Lock Manager | Scaling Postgres 306 14:29

1 year پیش14:29

14:29

In this episode of Scaling Postgres, we discuss one configuration change that resulted in an 11,000 times faster query, why Postgres is not using your index, backported PG improvements and parallelism with TOAST. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/306-scalability-limits-from-slru-lock-manager/…

Scaling Postgres

1
11K Faster Configuration Change | Scaling Postgres 305 13:26

1 year پیش13:26

13:26

Scaling Postgres

1
Overhead of pg_stat_statements | Scaling Postgres 304 14:09

1 year پیش14:09

14:09

In this episode of Scaling Postgres, we discuss new Postgres releases, performance comparisons between PgBouncer, PgCat and Supavisor, a new extension pg_analytics, and new planner capabilities in PG16. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/304-overhead-of-pg_stat_statements/…

Scaling Postgres

1 year پیش18:02

18:02

Scaling Postgres

1
Build A GPT In SQL | Scaling Postgres 299 12:21

1 year پیش12:21

12:21

Scaling Postgres

1
10-100 Times Higher Latency With Distributed Postgres | Scaling Postgres 298 19:28

1 year پیش19:28

19:28

In this episode of Scaling Postgres, we discuss hopes for Postgres in 2024, whether you need foreign keys, incremental backups, and five ways of doing not exists. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/298-10-100-times-higher-latency-with-distributed-postgres/…

Scaling Postgres

۳ years پیش17:51

17:51

In this episode of Scaling Postgres, we discuss 100x optimizations, how to audit table activity, designing schemas and how to set up table checksums. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/206-100x-optimizations-auditing-document-schema-designs-checksums/…

به Player FM خوش آمدید!

Player FM در سراسر وب را برای یافتن پادکست های با کیفیت اسکن می کند تا همین الان لذت ببرید. این بهترین برنامه ی پادکست است که در اندروید، آیفون و وب کار می کند. ثبت نام کنید تا اشتراک های شما در بین دستگاه های مختلف همگام سازی شود.