Toast Impact, zheap Storage, More Performance, pg_rewind Changes | Scaling Postgres 137

Scaling Postgres

Player FM - Internet Radio Done Right

60 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://ar.player.fm/legal.

Fixable

1
Unsolicited Advice: How to get your mojo back at work 35:43

منذ 12 weeks35:43

التشغيل لاحقا

قوائم

إعجاب

احب

35:43

Are you feeling overwhelmed, uninspired, or burned out at work? In this special Unsolicited Advice episode, Anne and Frances are getting ready for summer by tackling the importance of rest and the power of intention. They offer unexpected tips and tricks for recovering from constant stress, owning what you need to feel alive and engaged, and creating an experience of work that unleashes your ambition. Follow Hosts: Anne Morriss ( @annemorriss | LinkedIn: @anne-morriss ), Frances Frei ( @francesxfrei | LinkedIn: @francesfrei ) Links https://anneandfrances.com/ Subscribe to TED Instagram: @ted YouTube: @TED TikTok: @tedtoks LinkedIn: @ted-conferences Website: ted.com Podcasts: ted.com/podcasts For the full text transcript, visit ted.com/podcasts/fixable-transcripts Hosted on Acast. See acast.com/privacy for more information.…

منذ 5 أعوام 21:14

MP3•منزل الحلقة

In this episode of Scaling Postgres, we discuss the impact of toast, zheap storage results, more Postgres 13 performance data and changes to pg_rewind.

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

https://www.scalingpostgres.com/episodes/137-toast-impact-zheap-storage-more-performance-pg_rewind_changes/

548 حلقات

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

Scaling Postgres

Toast Impact, zheap Storage, More Performance, pg_rewind Changes | Scaling Postgres 137

Scaling Postgres

60 subscribers

published منذ 5 أعوام

MP3•منزل الحلقة

In this episode of Scaling Postgres, we discuss the impact of toast, zheap storage results, more Postgres 13 performance data and changes to pg_rewind.

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

https://www.scalingpostgres.com/episodes/137-toast-impact-zheap-storage-more-performance-pg_rewind_changes/

548 حلقات

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

كل الحلقات

Scaling Postgres

1
OrioleDB More Free? | Scaling Postgres 383 13:20

منذ 3 أيام13:20

13:20

In this episode of Scaling Postgres, we discuss free availability of an OrioleDB patent, pgEdge going open source, pg_duckdb hitting 1.0 and methods resolve to slow order by limit queries. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/383-orioledb-more-free/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
DB LLM Agents? | Scaling Postgres 382 19:03

منذ 10 أيام19:03

19:03

In this episode of Scaling Postgres, we discuss using a LLM as an agent, the importance of partitioned table statistics, PG 18 RC1, primary keys in sharded databases and a blue/green rollback. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/382-db-llm-agents/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
DocumentDB Movement | Scaling Postgres 381 9:44

منذ 17 يومًا9:44

9:44

In this episode of Scaling Postgres, we discuss DocumentDB moving to the Linux Foundation, multi-column indexes, SCRAM pass-through and RDS Proxy oddities. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/381-documentdb-movement/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Storage Engine Progress? | Scaling Postgres 380 14:53

منذ 24 يومًا14:53

14:53

In this episode of Scaling Postgres, we discuss enhancements to Oriole DB, new Postgres releases, a logging guide and application framework frustrations. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/380-storage-engine-progress/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Unconventional Advice? | Scaling Postgres 379 19:03

منذ 4 weeks19:03

19:03

In this episode of Scaling Postgres, we discuss when you should reindex, how to handle case insensitive data, how to index jsonb and the top recommendations when doing performance optimizations. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/379-unconventional-advice/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Native Column Store? | Scaling Postgres 378 19:29

منذ 5 weeks19:29

19:29

In this episode of Scaling Postgres, we discuss Postgres getting a native column store via an index, faster btree_gift indexes, scaling listen/notify, and a logical replication slot deep dive. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/378-native-column-store/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Sharding At Network Speeds | Scaling Postgres 377 15:14

منذ 6 weeks15:14

15:14

In this episode of Scaling Postgres, we discuss how to shard your DB at network speeds, how to make your DB 42,000 slower, new monitoring and just enough text searching performance. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/377-sharding-at-network-speeds/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
100K Events Per Second Queue | Scaling Postgres 376 19:45

منذ 7 weeks19:45

19:45

In this episode of Scaling Postgres, we discuss a 100K events per second queue built on Postgres, how an MCP can leak your database, MultiXact ID and space overrun and struggles starting Postgres. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/376-100k-events-per-second-queue/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
All The Benchmarks | Scaling Postgres 375 16:19

منذ 8 weeks16:19

16:19

In this episode of Scaling Postgres, we discuss new benchmarks as a result of the Planetscale Postgres announcement, various platform improvements and a deep dive into Multigres. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/375-all-the-benchmarks/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Migrating Millions Of Databases | Scaling Postgres 374 18:34

منذ 9 weeks18:34

18:34

In this episode of Scaling Postgres, we discuss how Jira migrated millions of databases, when sigterm does nothing, should you ditch vector search and mastering replication slots. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/374-migrating-millions-of-databases/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Planetscale Postgres! | Scaling Postgres 373 14:22

منذ 10 weeks14:22

14:22

In this episode of Scaling Postgres, we discuss the release of Planetscale Postgres and the advantages for bare metal, how often queries are optimal, avoiding UUIDv4 and the summer of upgrade report. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/373-planetscale-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/…

Scaling Postgres

1
The Future of Postgres Architecture | Scaling Postgres 372 19:26

منذ 11 weeks19:26

19:26

In this episode of Scaling Postgres, we discuss some possible futures for Postgres architectures, choosing a multi-tenancy model, vectors in the new SQL standard and one way to perform a blue-green deployment rollback in AWS RDS. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/372-the-future-of-postgres-architecture/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Are You Hurting Your Performance? | Scaling Postgres 371 21:08

منذ 12 weeks21:08

21:08

In this episode of Scaling Postgres, we discuss how you use the database can impact its performance, performance of pg_search, fast uploads and some downsides of different upgrade methods. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/371-are-you-hurting-your-performance/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

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

منذ 13 weeks14: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/…

Scaling Postgres

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

منذ 14 weeks18: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/…

Scaling Postgres

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

منذ 15 weeks19: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/…

Scaling Postgres

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

منذ 16 weeks13: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/…

Scaling Postgres

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

منذ 17 weeks14: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/…

Scaling Postgres

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

منذ 18 weeks20: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/…

Scaling Postgres

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

منذ 19 weeks20: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/…

Scaling Postgres

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

منذ 20 weeks13: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/…

Scaling Postgres

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

منذ 21 weeks12: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/…

Scaling Postgres

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

منذ 22 weeks17: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/…

Scaling Postgres

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

منذ 23 weeks16: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/…

Scaling Postgres

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

منذ 24 weeks18: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/…

Scaling Postgres

1
Postgres Conference 2025 | Scaling Postgres 358 23:37

منذ 25 weeks23: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/…

Scaling Postgres

1
Postgres Best Practices? | Scaling Postgres 357 9:58

منذ 26 weeks9:58

9:58

In this episode of Scaling Postgres, we discuss best practices, caching monitoring statistics, a new vector extension called VectorChord and the importance of monitoring wait events. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/357-postgres-best-practices/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Is the Future Immutable? | Scaling Postgres 356 15:21

منذ 27 weeks15:21

15:21

In this episode of Scaling Postgres, we discuss immutability and Postgres, the upcoming Postgres Conference in Orlando, extended statistics and usage of default partitions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/356-is-the-future-immutable/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Top Ten Analytics with pg_mooncake | Scaling Postgres 355 15:59

منذ 28 weeks15:59

15:59

In this episode of Scaling Postgres, we discuss how Postgres & pg_mooncake achieves top ten Clickbench results, a comparison of Oracle and Postgres transactions, sharding to scale and connection counts. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/355-top-ten-analytics-with-pg_mooncake/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Postgres & The US Treasury Attack | Scaling Postgres 354 15:43

منذ 29 weeks15:43

15:43

In this episode of Scaling Postgres, we discuss the role of Postgres in the US Treasury online attack, new releases of Postgres, optimizing application of streaming changes and a query that filled a databases disks. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/354-postgres-us-treasury-attack/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
OLTP To Parquet For Analytics | Scaling Postgres 353 15:59

منذ 30 weeks15:59

15:59

In this episode of Scaling Postgres, we discuss how data can flow from your OLTP to parquet files for analytics, parallel queries, view inlining and partitioning advice. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/353-oltp-to-parquet-for-analytics/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
You Can Always Optimize More | Scaling Postgres 352 14:32

منذ 31 weeks14:32

14:32

In this episode of Scaling Postgres, we discuss how you can always optimize more, avoiding deadlocks, casting & indexes and pg_hint_plan best practices. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/352-you-can-always-optimize-more/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Features To Avoid? | Scaling Postgres 351 16:55

منذ 32 weeks16:55

16:55

In this episode of Scaling Postgres, we talk about some features you may want to avoid like commit_delay, index_cleanup off, & logon triggers, a way to detect a table rewrite and a zero downtime upgrade. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/351-features-to-avoid/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Seven Years of Scaling Postgres | Scaling Postgres 350 19:09

منذ 33 weeks19:09

19:09

In this episode of Scaling Postgres, we discuss our seven year anniversary, better pg_search performance, reducing table locks, not valid constraints and better group by statistics. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/350-seven-years-of-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/…

Scaling Postgres

1
The Dangers of Temporary Tables | Scaling Postgres 349 15:24

منذ 34 weeks15:24

15:24

In this episode of Scaling Postgres, we discuss the dangers of temporary tables, better transparent data encryption, pig the extension wizard, and table level lock considerations. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/349-the-dangers-of-temporary-tables/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
The Future Is Containers? | Scaling Postgres 348 12:28

منذ 35 weeks12:28

12:28

In this episode of Scaling Postgres, we discuss whether the future of containers and Postgres, UUIDv7 commit, and a pg_duckdb interview. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/348-the-future-is-containers/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Easy Incremental Data Processing? | Scaling Postgres 347 14:47

منذ 38 weeks14:47

14:47

In this episode of Scaling Postgres, we discuss the new pg_incremental extension for processing data pipelines, a set of Postgres monitoring queries, handling alter table retries and large object dump performance. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/347-easy-incremental-data-processing/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Things I Don't Do In Postgres | Scaling Postgres 346 15:47

منذ 39 weeks15:47

15:47

In this episode of Scaling Postgres, we discuss things I do not do such as use default partitions, play column Tetris, ELT using special data types or create 7+ millions tables in a database. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/346-things-i-do-not-do-in-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/…

Scaling Postgres

1
Over 5X Faster Postgres? | Scaling Postgres 345 17:02

منذ 40 weeks17:02

17:02

In this episode of Scaling Postgres, we discuss OrioleDB getting Postgres over 5 times faster, historical OLAP performance, efficient queries and whether you should us track_planning. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/345-over-5x-faster-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/…

Scaling Postgres

1
Performance & Hard Things | Scaling Postgres 344 17:38

منذ 41 weeks17:38

17:38

In this episode of Scaling Postgres, we discuss new releases, collation speed, ZFS performance, insert benchmarking and pglz vs. lz4 performance. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/344-performance-hard-things/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Postgres Release Warning! | Scaling Postgres 343 18:50

منذ 42 weeks18:50

18:50

In this episode of Scaling Postgres, we discuss new Postgres releases and an out-of-band release to address issues, increasing insert performance by 2X, pg_search benchmarks and fast OpenStreetMap loading. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/343-postgres-release-warning/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Faster Writes With ZFS? | Scaling Postgres 342 13:19

منذ 43 weeks13:19

13:19

In this episode of Scaling Postgres, we discuss the read and write performance of Postgres on ZFS, handling URL text identifiers in the database, denormalization and a new pgvector release. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/342-faster-writes-with-zfs/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
The Future of Postgres Upgrades | Scaling Postgres 341 14:15

منذ 44 weeks14:15

14:15

In this episode of Scaling Postgres, we discuss the future of Postgres upgrades, the usefulness of pg_dump, partitioning with minimal downtime and limitless Aurora. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/341-the-future-of-postgres-upgrades/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Do You Need A Vectorizer? | Scaling Postgres 340 16:39

منذ 45 weeks16:39

16:39

In this episode of Scaling Postgres, we discuss whether you need a vectorizer, different ways to bin or bucket timestamps, addressing a bad plan and advanced psql. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/340-do-you-need-a-vectorizer/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

Scaling Postgres

1
Postgres Goes Parquet | Scaling Postgres 339 11:32

منذ 46 weeks11:32

11:32

In this episode of Scaling Postgres, we discuss pg_parquet allowing Postgres to read and write parquet files, other useful extensions, open source bounties, and Postgres gotchas. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/339-postgres-goes-parquet/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/…

مرحبًا بك في مشغل أف ام!

يقوم برنامج مشغل أف أم بمسح الويب للحصول على بودكاست عالية الجودة لتستمتع بها الآن. إنه أفضل تطبيق بودكاست ويعمل على أجهزة اندرويد والأيفون والويب. قم بالتسجيل لمزامنة الاشتراكات عبر الأجهزة.