# Robert Haas VP, Chief Database Scientist @ EnterpriseDB, PostgreSQL Major Contributor and Committer This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles. ## Hacking Workshop for September 2026 DevFeed: [Hacking Workshop for September 2026]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2026-07-31T15:09:42Z Content type: news Language: en Sources: [Robert Haas]() Topics: [PostgreSQL](), [Code]() Tags: [2026](), [announce](), [code](), [examples](), [mentoring](), [postgresql](), [september-2026](), [sessions](), [sign-up](), [talk](), [workshop]() ### AI overview This announcement invites readers to a September 2026 Hacking Workshop featuring David Rowley discussing hot-path code optimization and tuple deformation. Participants are asked to watch the talk beforehand and join a session with questions. ### Source excerpt I'm pleased to announce that David Rowley will be joining us in September to discuss his talk Optimizing code in the hot path; with examples from tuple deformation. If you're interesting in joining us, please sign up using this form and I will send you an invite to one of the sessions. As always, thanks to David for agreeing to join the sessions. Read more " ## Hacking Workshop for June/July 2026 DevFeed: [Hacking Workshop for June/July 2026]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2026-06-02T18:36:18Z Content type: news Language: en Sources: [Robert Haas]() Topics: [Hacking](), [PostgreSQL](), [IO](), [observability]() Tags: [2026](), [announce](), [hacking](), [io](), [mentoring](), [observability](), [postgresql](), [sessions](), [sign-up]() ### AI overview The June/July 2026 PostgreSQL Hacking Workshop will feature Melanie Plageman discussing her talk "Additional IO Observability in Postgres with pg_stat_io." Interested participants can sign up to receive an invitation. ### Source excerpt I was hoping to usual resume the monthly cadence of hacking workshops in June, but it didn't quite happen, largely due to being a little exhausted after pgconf.dev. But, I'm pleased to announce that Melanie Plageman will be joining us to discuss her talk Additional IO Observability in Postgres with pg_stat_io. If you're interesting in joining us, please sign up using this form and I will send you an invite to one of the sessions. As always, thanks to Melanie for joining us.Read more " ## Hacking Workshop for April/May 2026 DevFeed: [Hacking Workshop for April/May 2026]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2026-03-18T19:47:00Z Content type: opinion Language: en Sources: [Robert Haas]() Topics: [PostgreSQL](), [Hacking]() Tags: [2026](), [conference](), [event](), [hacking](), [mentoring](), [postgresql](), [workshop]() ### AI overview The author plans a combined April and May hacking workshop covering Masahiko Sawada's PGCon 2022 talk, "Breaking away from FREEZE and Wraparound." Interested participants can sign up to receive an invitation. The post also mentions PGConf.dev 2026, scheduled for May 19-22 at Simon Fraser University in Vancouver, Canada. ### Source excerpt I'm planning to hold a single hacking workshop for April and May combined, covering Masahiko Sawada's talk, Breaking away from FREEZE and Wraparound, given at PGCon 2022. If you're interested in joining us, please sign up using this form and I will send you an invite to one of the sessions. Thanks to Sawada-san for agreeing to join us. Read more " ## pg\_plan\_advice: Plan Stability and User Planner Control for PostgreSQL? DevFeed: [pg\_plan\_advice: Plan Stability and User Planner Control for PostgreSQL?]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2026-03-04T17:55:00Z Content type: opinion Language: en Sources: [Robert Haas]() Topics: [PostgreSQL](), [JOIN](), [modules](), [Query (disambiguation)]() Tags: [join](), [modules](), [plan](), [planner](), [postgresql](), [query](), [test]() ### AI overview The article presents a proposed PostgreSQL 19 patch set introducing the pg_plan_advice, pg_collect_advice, and pg_stash_advice contrib modules. It demonstrates how pg_plan_advice can generate plan advice strings, preserve selected planner decisions, or vary advice to produce a different join plan. ### Source excerpt I'm proposing a very ambitious patch set for PostgreSQL 19. Only time will tell whether it ends up in the release, but I can't resist using this space to give you a short demonstration of what it can do. The patch set introduces three new contrib modules, currently called pg_plan_advice, pg_collect_advice, and pg_stash_advice. Read more " ## Hacking Workshop for March 2026 DevFeed: [Hacking Workshop for March 2026]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2026-02-19T02:43:00Z Content type: article Language: en Sources: [Robert Haas]() Topics: [PostgreSQL](), [Development]() Tags: [2026](), [development](), [event](), [mentoring](), [postgresql](), [workshop]() ### AI overview An announcement for a March 2026 hacking workshop featuring two or three discussions of Tomas Vondra's talk "Performance Archaeology," with sessions intended for people interested in PostgreSQL development and existing PostgreSQL hackers. ### Source excerpt For next month's hacking workshop, I'm scheduling 2 or 3 discussions of Tomas Vondra's talk, Performance Archaeology, given at 2024.PGConf.EU. If you're interested in joining us, please sign up using this form and I will send you an invite to one of the sessions. Thanks as always to Tomas for agreeing to attend the sessions. Read more " ## Who Contributed to PostgreSQL Development in 2025? DevFeed: [Who Contributed to PostgreSQL Development in 2025?]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2026-01-19T15:29:00Z Content type: article Language: en Sources: [Robert Haas]() Topics: [PostgreSQL](), [Development](), [Code](), [Statistics]() Tags: [2025](), [blog](), [blog-post](), [code](), [contributed](), [contributions](), [development](), [postgresql](), [statistics]() ### AI overview An annual analysis of PostgreSQL code contributions in 2025 counts 266 principal authors and reports the concentration of new lines of code and commits among contributors. The author notes that the methodology has significant limitations and does not capture all important work. ### Source excerpt Here is another annual blog post breaking down code contributions to PostgreSQL itself (not ecosystem projects) by principal author. I have mentioned every year that this methodology has many limitations and fails to capture a lot of important work, and I reiterate that this year as usual. Nonetheless, many people seem to find these statistics helpful, so here they are. Read more " ## Hacking Workshop for February 2026 DevFeed: [Hacking Workshop for February 2026]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2026-01-15T18:26:00Z Content type: article Language: en Sources: [Robert Haas]() Topics: [PostgreSQL](), [Process]() Tags: [2026](), [hacking](), [mentoring](), [postgresql](), [workshop]() ### AI overview A February 2026 hacking workshop will host two or three small-group discussions about Amit Langote's talk, "Hacking Postgres Executor For Performance," presented at PGConf India 2025. Participants can discuss PostgreSQL technology, project choices, and the community patch process with the speaker. ### Source excerpt For next month, I'm scheduling 2 or 3 discussions of Amit Langote's talk, Hacking Postgres Executor For Performance, given at PGConf India 2025. If you're interested in joining us, please sign up using this form and I will send you an invite to one of the sessions. Thanks to Amit for agreeing to attend the sessions.Read more " ## The Future of the PostgreSQL Hacking Workshop DevFeed: [The Future of the PostgreSQL Hacking Workshop]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2025-12-04T18:58:00Z Content type: opinion Language: en Sources: [Robert Haas]() Topics: [PostgreSQL](), [Development](), [aio]() Tags: [2025](), [2026](), [conferences](), [discord](), [mentoring](), [postgresql](), [talks](), [videos](), [workshop]() ### AI overview The PostgreSQL Hacking Workshop will take a break in December 2025, and its future schedule is uncertain because finding enough suitable online talks has become difficult. The series may occur less frequently or use panel discussions, with a talk on AIO planned for January 2026. ### Source excerpt The PostgreSQL Hacking Workshop will be taking a well-earned Christmas break in December of 2025. The future of the workshop is a little bit unclear, because I'm continuing to have a bit of trouble finding enough good talks online to justify doing one per month: the best source of talks for the event is pgconf.dev, but not all of those talks are about hacking on PostgreSQL, and not all of those that are about hacking are equally interesting to potential attendees. Also, we've already eaten through much of the backlog of older hacking-related talks that are posted online. Many conferences have few hacking-related talks, or just don't post any videos (which are expensive and time-consuming to produce). Read more " ## Hacking Workshop for November 2025 DevFeed: [Hacking Workshop for November 2025]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2025-10-16T13:36:00Z Content type: news Language: en Sources: [Robert Haas]() Topics: [Scalability]() Tags: [mentoring](), [postgresql](), [scalability]() ### AI overview The article announces two or three November discussions about Matthias van de Meent's talk on improving scalability and reducing overhead in shared memory. Participants can sign up to receive an invitation. ### Source excerpt For next month, I'm scheduling 2 or 3 discussions of Matthias van de Meent's talk, Improving scalability; Reducing overhead in shared memory, given at 2025.pgconf.dev (talk description here). If you're interested in joining us, please sign up using this form and I will send you an invite to one of the sessions. Thanks to Matthias for agreeing to attend the sessions, and to Melanie Plageman for agreeing to serve as host. (I normally host, but am taking a month off. We will also skip December due to the end-of-year holidays.) ## Hacking Workshop for October 2025 DevFeed: [Hacking Workshop for October 2025]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2025-09-12T13:25:00Z Content type: article Language: en Sources: [Robert Haas]() Topics: [PostgreSQL](), [Development]() Tags: [2025](), [mentoring](), [postgresql](), [workshop]() ### AI overview An October 2025 workshop will host two or three discussions of Thomas Munro's talk on investigating multithreaded PostgreSQL. Participants of all experience levels are invited, and attendees will receive a session invitation after signing up. ### Source excerpt Next month, I'll be hosting 2 or 3 discussions of Thomas Munro's talk, Investigating Multithreaded PostgreSQL, given at 2025.pgconf.dev (talk description here). If you're interested in joining us, please sign up using this form and I will send you an invite to one of the sessions. Thanks to Thomas for agreeing to attend the sessions. As usual, nobody is too inexperienced to join us, and nobody is too experienced. We have everyone from total newcomers to interested committers. ## Hacking Workshop for September 2025 DevFeed: [Hacking Workshop for September 2025]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2025-08-14T15:24:00Z Content type: article Language: en Sources: [Robert Haas]() Topics: [Development](), [C](), [cpu](), [PostgreSQL]() Tags: [2025](), [c](), [cpu](), [mentoring](), [postgresql](), [workshop]() ### AI overview The author announces two or three September discussions of David Rowley's talk, "Writing fast C code for a modern CPU (and applying it to PostgreSQL)," presented at 2025.pgconf.dev. Interested participants can sign up to receive an invitation. ### Source excerpt Next month, I'll be hosting 2 or 3 discussions of David Rowley's talk, Writing fast C code for a modern CPU (and applying it to PostgreSQL), given at 2025.pgconf.dev (talk description here). If you're interested in joining us, please sign up using this form and I will send you an invite to one of the sessions. Thanks to David for agreeing to attend the sessions. As usual, nobody is too inexperienced to join us, and nobody is too experienced. We have everyone from total newcomers to interested committers. ## One Year of Hacking Workshops DevFeed: [One Year of Hacking Workshops]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2025-07-17T20:24:00Z Content type: article Language: en Sources: [Robert Haas]() Topics: [Hacking](), [PostgreSQL]() Tags: [hacking](), [mentoring](), [postgresql](), [workshops]() ### AI overview Robert Haas reviews the first year of PostgreSQL Hacking Workshops, covering participation, recurring attendance, speaker involvement, discussion quality, and opportunities to attract more newcomers. ### Source excerpt I started running PostgreSQL Hacking Workshops just about one year ago, and I've run one each month, except for May, when we had pgconf.dev. Signups are now open for August, if you're interested in joining us for a discussion of Peter Geoghan's talk on Multidimensional search strategies for composite B-Tree indexes, but I'd also like to take a few minutes to summarize where we are after one year of hacking workshops, both the good and the maybe not quite as good. So here goes. Read more " ## PostgreSQL Hacking + Patch Review Workshops for July 2025 DevFeed: [PostgreSQL Hacking + Patch Review Workshops for July 2025]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2025-06-19T18:01:00Z Content type: news Language: en Sources: [Robert Haas]() Topics: [PostgreSQL](), [Development]() Tags: [2025](), [mentoring](), [postgresql](), [workshops]() ### AI overview The article announces July 2025 PostgreSQL patch review workshops and planned discussions of Tomas Vondra's talk on fast-path locking improvements in PG18. Participants can sign up for sessions and collaborate in teams on patch reviews. ### Source excerpt Next month, I'll be hosting 2 or 3 discussions of Tomas Vondra's talk, Fast-path locking improvements in PG18, given at 2025.pgconf.dev (talk description here). If you're interested in joining us, please sign up using this form and I will send you an invite to one of the sessions. Thanks to Tomas for agreeing to attend the sessions. We'll have plenty more 2025.pgconf.dev talks on the schedule in future months, as well! As usual, nobody is too inexperienced to join us, and nobody is too experienced. We have everyone from total newcomers to interested committers. Read more " ## Hacking Workshop for June 2025 DevFeed: [Hacking Workshop for June 2025]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2025-05-19T12:00:00Z Content type: article Language: en Sources: [Robert Haas]() Topics: [PostgreSQL](), [meetings](), [zoom]() Tags: [meetings](), [mentoring](), [postgresql](), [sessions](), [sign-up](), [workshop](), [zoom]() ### AI overview An upcoming workshop will host two or three Zoom discussions of Masahiko Sawada's talk on using Adaptive Radix Trees to speed up PostgreSQL vacuuming. Participants are asked to watch the talk beforehand and sign up to receive an invitation. ### Source excerpt Next month, I'll be hosting 2 or 3 discussions of Masahiko Sawada's talk, PostgreSQL meets ART - Using Adaptive Radix Tree to speed up vacuuming, from 2024.pgconf.dev. If you're interested in joining us, please sign up using this form and I will send you an invite to one of the sessions. Read more " ## Mentoring Applications and Hacking Workshop for April 2025 DevFeed: [Mentoring Applications and Hacking Workshop for April 2025]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2025-03-19T15:04:00Z Content type: news Language: en Sources: [Robert Haas]() Topics: [PostgreSQL](), [Hacking](), [.NET Conf]() Tags: [2025](), [hacking](), [mentoring](), [postgresql](), [workshop]() ### AI overview A March 2025 update announces a one-on-one mentoring program for PostgreSQL contributors, an April discussion of a talk about autovacuum, and plans to skip the May hacking workshop because of 2025.pgconf.dev. ### Source excerpt Here are a few mentoring-related updates.Read more " ## PostgreSQL Hacking + Patch Review Workshops - March 2025 DevFeed: [PostgreSQL Hacking + Patch Review Workshops - March 2025]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2025-02-20T19:57:00Z Content type: news Language: en Sources: [Robert Haas]() Topics: [PostgreSQL](), [Code review](), [Code]() Tags: [2025](), [developer](), [discord](), [fosdem](), [mentoring](), [postgresql](), [review](), [workshops]() ### AI overview The PostgreSQL Hacking Workshop is returning in March 2025 alongside a new Patch Review Workshop organized by Paul Jungwirth. The article explains how patch review can help onboard PostgreSQL developers and notes the renaming of a related Discord server. ### Source excerpt This month, I'm excited to tell you about the returning of the PostgreSQL Hacking Workshop along with a new Patch Review Workshop organized by Paul Jungwirth.Read more " ## Who Contributed to PostgreSQL Development in 2024? DevFeed: [Who Contributed to PostgreSQL Development in 2024?]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2025-01-22T20:55:00Z Content type: article Language: en Sources: [Robert Haas]() Topics: [PostgreSQL](), [Development](), [data](), [Code]() Tags: [contributions](), [development](), [postgresql](), [repository]() ### AI overview The article presents 2024 contribution statistics for the PostgreSQL repository. It reports 229 principal commit authors, with 66% of new lines contributed by 18 people and 90% by 47 people, while noting that the analysis is not comprehensive and does not cover related projects. ### Source excerpt People continue to tell me on a semi-regular basis how much they appreciate these approximately annual posts, the first of which came out in April of 2017. I think this might be more because the project doesn't have enough official ways to recognize people than it is an endorsement of the particular thing that I've done here, the limitations of which I am always careful to mention. In particular, I do not intend this as a comprehensive picture of contributions to the project, or even to development activity; and I lack the data to fairly divide credit for a single commit between multiple individuals. Nevertheless, I am very grateful to all the people who have expressed appreciation for these posts, or told me about the value that they derived from them. Thank you so much. Read more " ## PostgreSQL Hacking Workshop - February 2025 DevFeed: [PostgreSQL Hacking Workshop - February 2025]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2025-01-17T19:02:00Z Content type: news Language: en Sources: [Robert Haas]() Topics: [PostgreSQL](), [meetings](), [Protocol (disambiguation)]() Tags: [meetings](), [mentoring](), [postgresql](), [programming](), [protocol](), [virtual](), [zoom]() ### AI overview An online PostgreSQL hacking workshop in February 2025 will discuss Heikki Linnakangas's talk on The Wire Protocol from PGCONF.EU 2024. Participants will watch the talk and join one of two or three Zoom discussion meetings, with attendees of all experience levels welcome. ### Source excerpt Please considering joining us next month (February 2025) for a discussion of Heikki Linnakangas's talk on The Wire Protocol, from PGCONF.EU 2024. For those not familiar with the concept, this hacking workshop is basically a virtual meetup: you watch the talk, and then you sign up to participate in one of two or three Zoom meetings where we discuss the talk. Usually, we're able to get the original author of the talk to join us; thanks to Heikki for agreeing to join us this month. Read more " ## How to Submit Talks for 2025.pgconf.dev DevFeed: [How to Submit Talks for 2025.pgconf.dev]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2024-12-20T14:10:00Z Content type: opinion Language: en Sources: [Robert Haas]() Topics: [PostgreSQL](), [Development]() Tags: [developer](), [event](), [opinion](), [postgresql](), [talks]() ### AI overview This post encourages developers to submit proposals to 2025.pgconf.dev and offers personal guidance on talk topics, including PostgreSQL war stories and industry developments. ### Source excerpt The call for proposals for 2025.pgconf.dev has been extended to January 6, 2025, otherwise known as "very soon". I'm writing this post to encourage you to submit, if you haven't done so yet, regardless of whether you have submitted to 2024.pgconf.dev or its predecessor, PGCon, in the past. The event will only be as good as the content you (collectively) submit, and having found much value in these events over the years that I've been participating, I very much want our future events to be as good as those in the past, or, hopefully, even better. But what makes a good event, and what kind of talk should you submit? Read more " ## PostgreSQL Hacking Workshop - January 2025 DevFeed: [PostgreSQL Hacking Workshop - January 2025]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2024-12-12T15:19:00Z Content type: news Language: en Sources: [Robert Haas]() Topics: [PostgreSQL](), [Hacking](), [NUMA](), [Discord]() Tags: [2025](), [discord](), [hacking](), [mentoring](), [numa](), [postgresql](), [workshop]() ### AI overview The article announces January 2025 discussion workshops about Andres Freund's "NUMA vs PostgreSQL" talk from PGConf.EU 2024. Sessions are planned for 1400 and 2000 UTC, with a possible third session at 1700 UTC if demand is sufficient. It also previews PostgreSQL discussions planned for February and March and promotes the PostgreSQL Hacker Mentoring Discord server. ### Source excerpt Next month, I'l be hosting 2 or 3 discussions of Andres Freund's talk, NUMA vs PostgreSQL, given at PGConf.EU 2024. You can sign up using this form. I anticipate that both Andres and I will be present for the discussions, and I'd like to thank Andres and all of the other presenters who have made time to join the discussions and answer questions for their time (so far: Melanie Plageman, Thomas Munro, Andrey Borodin). It has been absolutely great having them join the workshops. Read more " ## PostgreSQL Hacking Workshop - December 2024 DevFeed: [PostgreSQL Hacking Workshop - December 2024]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2024-11-14T13:01:00Z Content type: article Language: en Sources: [Robert Haas]() Topics: [PostgreSQL](), [Databases]() Tags: [mentoring](), [postgresql](), [workshop]() ### AI overview An announcement for a December 2024 PostgreSQL hacking workshop discussing Melanie Plageman's PGCon 2019 talk on the PostgreSQL planner. The post explains that the workshop will have two sessions, discusses attendance and scheduling, and notes the participation of experienced PostgreSQL hackers and database users. ### Source excerpt Next month, I'll be hosting a discussion of Melanie Plageman's talk, Intro to Postgres Planner, given at PGCon 2019. You can sign up using this form. To be clear, the talk is not an introduction to how the planner works from a user perspective, but rather how to hack on it and try to make it better and perhaps get your improvements committed to PostgreSQL. If you're interested, please join us. I anticipate that both Melanie and I will be present for the discussions. Read more " ## Why pg\_dump Is Useful for PostgreSQL Data Migration and Troubleshooting DevFeed: [Why pg\_dump Is Useful for PostgreSQL Data Migration and Troubleshooting]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2024-11-01T15:56:00Z Content type: opinion Language: en Sources: [Robert Haas]() Topics: [PostgreSQL](), [postgresql clusters](), [Databases](), [cpu](), [floating-point]() Tags: [backup](), [backups](), [cpu](), [database](), [floating-point](), [pg-dump](), [postgresql](), [sql](), [version]() ### AI overview The article explains why pg_dump is useful beyond full-cluster backups. Its human-readable SQL output can support database migration, major-version changes, CPU architecture changes, and troubleshooting, although it may require manual modification and can incur performance costs or fail in some cases. ### Source excerpt I wrote a blog post a couple of weeks ago entitled Is pg_dump a Backup Tool?. In that post, I argued in the affirmative, but also said that it's probably shouldn't be your primary backup mechanism. For that, you probably shouldn't directly use anything that is included in PostgreSQL itself, but rather a well-maintained third-party backup tool such as barman or pgbackrest. But today, I want to talk a little more about why I believe that pg_dump is both amazingly useful for solving all kinds of PostgreSQL-related problems and also just a great piece of technology. Read more " ## PostgreSQL Hacking Workshop - November 2024 DevFeed: [PostgreSQL Hacking Workshop - November 2024]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2024-10-24T12:35:00Z Content type: article Language: en Sources: [Robert Haas]() Topics: [PostgreSQL](), [Database](), [Cache]() Tags: [cache](), [database](), [mentoring](), [postgresql](), [workshop]() ### AI overview A November 2024 PostgreSQL hacking workshop will discuss Andy Pavlo's talk on memory and disk I/O management. The sessions will examine how the talk's material relates to PostgreSQL, especially the shared buffer cache, and participants can sign up for one of three discussion sessions. ### Source excerpt Next month, I'll be hosting a discussion of a talk by Andy Pavlo, given for his Intro to Database Systems course at CMU. The title of the talk is "Memory & Disk I/O Management and the video link is https://www.youtube.com/watch?v=aoewwZwVmv4. As usual, we have will have three sessions, and you can sign up to participate in one of them using this form. Read more " ## Is pg\_dump a Backup Tool? DevFeed: [Is pg\_dump a Backup Tool?]() Original publisher: [Read original article]() Author: Robert Haas (noreply@blogger.com) Published: 2024-10-15T20:03:00Z Content type: opinion Language: en Sources: [Robert Haas]() Topics: [PostgreSQL](), [Databases](), [configuration]() Tags: [backup](), [backups](), [configuration](), [database](), [pg-dump](), [pg-dumpall](), [postgresql]() ### AI overview The article argues that pg_dump and pg_dumpall can function as backup tools because they can save database data and restore it later. It also explains that this approach may be unsuitable for large databases due to slow backups and restores, possible database bloat, version-related restore errors, and the need to separately preserve globals and configuration files. ### Source excerpt Recently, I've been hearing a lot of experienced PostgreSQL users reiterate this line: "pg_dump is not a backup tool." In fact, the documentation has recently been updated to avoid saying that it is a backup tool, to widespread relief. Experienced PostgreSQL users and developers have been publicly called out for having the temerity to assert that pg_dump is, in fact, a backup tool. I find this narrative deeply frustrating, for two reasons.Read more " [Next page]()