--- title: "The fastest way to copy data between tables" publication: "Postgres Weekly" issue: 565 published_at: "2024-07-31" canonical_url: "https://postgresweekly.com/issues/565" --- Plus an acquisition in the Postgres startup ecosystem. | #​565 — July 31, 2024 [Web Version](https://postgresweekly.com/issues/565) 🏖️ Just a quick note to say that we're taking the next two weeks off for a summer vacation. We'll be back with our next issue on Wednesday, August 21. __ _Peter Cooper, your editor_ Together with [![pgAnalyze\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_350,h_100/e_make_transparent/co_white,e_outline:7/lhwcvgc1asd4fzaahty4.png)](https://pganalyze.com/?utm_source=PostgresWeeklyPrimary07312024) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/uyzd9ns4dadbvyccch1t.jpg)](https://github.com/vyruss/pg_statviz) [pg_statviz: Time Series Analysis and Visualization of Postgres Stats](https://github.com/vyruss/pg_statviz) — An extension and utility pair for performing time series analysis and visualization of various stats around things like I/O, locks, WAL, and buffer use. The new [v0.7 release](https://github.com/vyruss/pg_statviz/releases/tag/v0.7) adds Postgres 17 support, new I/O stats, and Pandas resampling for collected data. Jimmy Angelakos [The Fastest Way to Copy Data Between Postgres Tables](https://ongres.com/blog/fastest_way_copy_data_between_postgres_tables/) — Anthony compares several methods, both using native SQL and extensions. The spoiler is that [pg_bulkload](https://github.com/ossc-db/pg_bulkload) wins by quite a way, though with some tradeoffs. Anthony Sotolongo [![\](https://copm.s3.amazonaws.com/2f33626a.png)](https://pganalyze.com/?utm_source=PostgresWeeklyPrimary07312024) [Find the Root Cause of Postgres Performance Problems](https://pganalyze.com/?utm_source=PostgresWeeklyPrimary07312024) — Slow queries making your application feel sluggish? Bloated tables causing unexpected I/O? Use pganalyze to deliver consistent database performance & availability through intelligent tuning advisors and in-depth monitoring. pganalyze sponsor [ClickHouse Acquires PeerDB for Native Postgres CDC Integration](https://blog.peerdb.io/clickhouse-acquires-peerdb-for-native-postgres-cdc-integration) — [PeerDB](https://github.com/PeerDB-io/peerdb) is a data replication tool built by former Microsoft and Citus Data employees for streaming data from Postgres to data warehouses, queues, and other storage engines. It seems data warehouse company [ClickHouse](https://clickhouse.com/) has seen the strategic value in bringing such tech in-house. Sai Srirampur [Designing a Prototype: Postgres Plan Freezing](https://danolivo.substack.com/p/designing-a-prototype-postgres-plan) — _Plan freezing_ is the idea of saving a specific plan for a parameterized query so it can be reused again in future as-is. Andrei explains the technicalities of implementing his extension (which you can also try out) to do this. Andrei Lepikhov **QUICK BITS:** - The results of _Stack Overflow_'s popular annual developer survey came out last week and [Postgres has topped the database chart](https://survey.stackoverflow.co/2024/technology#1-databases) for a second year, now being used by 48.7% of respondents. - Robert Haas has [announced a virtual _PostgreSQL Hacking Workshop_](https://rhaas.blogspot.com/2024/07/postgresql-hacking-workshop-august-2024.html) where in both August and September different technical Postgres talks will be discussed as a group. [What to Know About Linux Memory Overcommit with Postgres](https://www.cybertec-postgresql.com/en/what-you-should-know-about-linux-memory-overcommit-in-postgresql/) — Linux’s overcommit feature can allow for more memory to be allocated than is actually available. This has benefits in some cases, but it’s bad news for Postgres. Laurenz Albe [How to Keep a Postgres Community Alive](https://fljd.in/en/2024/07/30/how-to-keep-a-community-alive/) — Fresh off the excitement of [PG Day France](https://pgday.fr/), the author shares his thoughts on building up a local Postgres user group and running its meetings. Florent Jardin 📰 Classifieds [Blacksmith](https://blacksmith.sh/?ref=cooperpresspg) runs GitHub Actions up to 2x faster at half the cost with a one-line change. Trusted by 100+ companies like GitBook and Slope. --- Boost your PostgreSQL skills with [Redgate’s 101 webinar series](https://www.red-gate.com/hub/events/series/postgresql-101) of easy-to-follow, expert hosted sessions. It’s PostgreSQL, simplified. [Graph Retrieval with Recursive CTEs](https://www.sheshbabu.com/posts/graph-retrieval-using-postgres-recursive-ctes/) — Postgres _isn’t_ a ‘graph database’ but it can certainly handle graph related concepts. Sheshbabu Chinnakonda 📄 [The Basics of Connection Poolers](https://proopensource.it/blog/postgresql-connection-poolers) Stefanie Janine Stölting 📄 [Splitting and Merging Partitions in Postgres 17](https://pgdash.io/blog/splitting-merging-partitions-in-postgresql-17.html) pgDash 🛠 Code and Tools - [QuestDB 8.1](https://github.com/questdb/questdb) – Java-powered time-series database with Postgres wire protocol compatibility. [v8.1](https://github.com/questdb/questdb/releases/tag/8.1.0) can now read Parquet files. - [Pongo 0.8](https://github.com/event-driven-io/Pongo) – A Postgres driver for Node.js that presents itself with a MongoDB-style API. - [FerretDB 1.23](https://github.com/FerretDB/FerretDB) – A database that acts like MongoDB but uses Postgres for storage. - [pgxmock 4.2](https://github.com/pashagolub/pgxmock) – Mock driver to test database interactions in Go. - [Bytebase 2.22](https://github.com/bytebase/bytebase/releases/tag/2.22.0) – Database devops and CI/CD system for teams. - [RisingWave 1.10](https://github.com/risingwavelabs/risingwave/releases/tag/v1.10.0) – Postgres-compatible streaming database. - [pgAdmin 4 8.10](https://www.pgadmin.org/docs/pgadmin4/8.10/release_notes_8_10.html) – Popular Postgres administation tool. **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. _Thanks!_ --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*).