Is pg_dump A Backup Tool? | Scaling Postgres 331

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

This Is Woman's Work with Nicole Kalil

1
Invite the Tiger to Tea: How to Turn Stress Into Strength with Dr. Rebecca Heiss | 340 36:14

לפני 11 ימים36:14

הפעל מאוחר יותר

רשימות

לייק

אהבתי

36:14

We’ve been told stress will kill us. That we need to yoga-breathe it away, book a retreat, or stuff it down with a pint of Ben & Jerry’s (using your car key as a spoon… iykyk). But what if stress isn’t the villain? What if it’s actually the fuel for our best work? This week, we’re joined by Dr. Rebecca Heiss — a stress physiologist, researcher, keynote speaker, and author of Springboard: Transform Stress to Work for You . She’s also the creator of the Fearless Stress Formula and has been recognized by the National Science Foundation for her groundbreaking research. Her mission? To help us stop fearing fear, stop fighting stress, and instead transform both into fuel for growth, performance, and purpose. Rebecca brings her science background together with real talk and humor, making the hard stuff (like stress) not only make sense but feel doable. She’s passionate about helping women shift out of survival mode and into a place of clarity, confidence, and community. Together, we dive into why stress isn’t something to eliminate but energy we can reframe, channel, and actually use to show up stronger. We explore: Why your “effortless, overwhelmed” game isn’t working The three steps to stop fighting stress and start using it How to “invite the tiger to tea” (yes, really) Why service and community are the real antidote to overwhelm The competitive advantage women have when it comes to stress Because friend, stress isn’t proof you’re broken. It’s proof you care. And when you learn to use it, it becomes your edge. Connect with Rebecca: Website: www.rebeccaheiss.com Book: https://a.co/d/6ReB5Nr IG: https://www.instagram.com/drrebeccaheiss/ Related Podcast Episodes The Stress Paradox: Why We Need Stress (and How to Make It Work for Us) with Dr. Sharon Horesh Bergquist | 294 How to Become Panic Proof with Dr. Nicole Cain | 269 Stress Less and Fear(Less) with Rebecca Heiss | 181 Share the Love: If you found this episode insightful, please share it with a friend, tag us on social media, and leave a review on your favorite podcast platform! 🔗 Subscribe & Review: Apple Podcasts | Spotify | Amazon Music Learn more about your ad choices. Visit megaphone.fm/adchoices…

לפני שנה 17:31

MP3•בית הפרקים

In this episode of Scaling Postgres, we discuss whether pg_dump is a backup tool, the pgMonitor extension, Postgres malware, and application uses for the merge command.

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

https://www.scalingpostgres.com/episodes/331-is-pg_dump-a-backup-tool/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

547 פרקים

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

Is pg_dump A Backup Tool? | Scaling Postgres 331

Scaling Postgres

60 subscribers

published לפני שנה

שתפו

MP3•בית הפרקים

In this episode of Scaling Postgres, we discuss whether pg_dump is a backup tool, the pgMonitor extension, Postgres malware, and application uses for the merge command.

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

https://www.scalingpostgres.com/episodes/331-is-pg_dump-a-backup-tool/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

547 פרקים

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

כל הפרקים

Scaling Postgres

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

לפני 4 ימים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

לפני 11 ימים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

לפני 18 ימים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

לפני 25 ימים19: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/…

ברוכים הבאים אל Player FM!

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