--- title: "New security releases of Postgres all round" publication: "Postgres Weekly" issue: 382 published_at: "2020-11-18" canonical_url: "https://postgresweekly.com/issues/382" --- Plus how to migrate from Heroku to RDS, Google Cloud adds Postgres 13, and a JDBC performance tip. #382 — November 18, 2020 [Web Version](https://postgresweekly.com/issues/382) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/ultjzazwfrukgaealxsg.jpg)](https://www.cybertec-postgresql.com/en/pg_timetable-v3-is-out/) [pg_timetable v3 Released](https://www.cybertec-postgresql.com/en/pg_timetable-v3-is-out/) — An advanced PostgreSQL `cron`-compatible scheduler now with some new features including improved scheduling (e.g. ‘every 6 hours’), an option to forbid shell tasks, and interval tasks that can be run repeatedly. Pavlo Golub [Migrating Large Heroku Postgres Instances to AWS Aurora without Downtime](https://thecodinginterface.com/blog/heroku-postgres-migration-to-aurora/) — Heroku can make ops easy but the flexibility of RDS is appealing when you need to scale, reduce costs, or if there are other parts of the AWS ecosystem you want to work with. There’s a _lot_ to process and enjoy here as there were a lot of moving parts. Adam McQuistan [![\](https://copm.s3.amazonaws.com/418671b9.png)](https://www.postgresbuild.com/registration?SQF_SOURCE=Postgres-Weekly) [Postgres Build 2020 - PostgreSQL Online Conference [Free\]](https://www.postgresbuild.com/registration?SQF_SOURCE=Postgres-Weekly) — Listen to 25+ talks on the latest in PostgreSQL and on how PostgreSQL helps businesses. This conference will also provide wellness sessions to promote health and revitalize. Join us from December 8 - 9. [Register now](https://www.postgresbuild.com/registration?SQF_SOURCE=Postgres-Weekly). EDB sponsor [Postgres 13.1, 12.5, 11.10, 10.15, 9.6.20, and 9.5.24 Released](https://www.postgresql.org/about/news/postgresql-131-125-1110-1015-9620-and-9524-released-2111/) — Updates to all of the currently maintained lines of Postgres to tackle three security vulnerabilities (plus the usual small bug fixes). Upgrading is urged in particular due to one issue allowing a user with permission to create non-temporary objects to then execute arbitrary SQL functions under the identity of a superuser. PostgreSQL News [What’s New in the Citus 9.5 Extension to Postgres](https://www.citusdata.com/blog/2020/11/14/citus-9-5-whats-new/) — A walk through everything new in the Citus 9.5 open source extension that scales out Postgres horizontally. From Postgres 13 support to `undistribute_table` to adaptive connection management for `COPY`, and more. Claire Giordano (Microsoft) [Google Cloud SQL Adds Postgres 13 Support](https://cloud.google.com/blog/products/databases/cloud-sql-database-service-adds-postgresql-13) — Google’s fully managed Postgres database service can now run on the latest version. Google Cloud [Do This 10 Times And Stop... In Postgres](https://xzilla.net//blog/2020/Nov/Do-This-10-Times-And-Stop-dot-dot-dot-In-Postgres.html) — This is a really neat `psql` trick involving using `\gexec` to run the result of a query as a new query itself. Robert Treat [Full-Text Search Since PostgreSQL 8.3](https://www.2ndquadrant.com/en/blog/full-text-search-since-postgresql-8-3/) — Postgres has had full text search functionality for some time and it continues to get better. This post looks at its history and runs benchmarks over each key version from 8.3 to 13. Tomas Vondra [⚡️ 13 Tips to Improve PostgreSQL INSERTS](https://tsdb.co/faster-inserts-tips) — Get our top ways to speed up INSERTs, from optimizing disk performance to using parallel writes + batch inserts 🚀 Timescale sponsor [macOS Big Sur Allegedly Breaking Postgres Installations](https://pgsnake.blogspot.com/2020/11/macos-big-sur-upgrade-breaking.html) — The latest version of macOS may be causing issues with existing Postgres installs.. or it may not. If it is for you, maybe this tip will help. Dave Page [Postgres Streaming Replication on Windows: A Quick Guide](https://info.crunchydata.com/blog/postgres-streaming-replication-on-windows-a-quick-guide) Yorvi Arias [Some Performance Improvements Coming to PostGIS 3.1](https://info.crunchydata.com/blog/waiting-for-postgis-3.1-performance) Paul Ramsey [pgtt: Extension to Manage and Use Oracle-Style Global Temporary Tables](https://github.com/darold/pgtt) Gilles Darold supported by [![Cockroach Labs\](https://res.cloudinary.com/cpress/image/upload/v1605303042/oogpyi7rklssl1nsgrea.png)](https://www.cockroachlabs.com/?utm_campaign=cooperpress-2020-Q4&utm_source=postgresweekly&utm_medium=sponsor&utm_content=tip-of-the-week-batch-inserts) 💡**Tip of the Week** Speed up batch inserts when using JDBC For Java developers using the PostgreSQL JDBC driver, you can significantly speed up batch operations with the `reWriteBatchedInserts` connection parameter. If `reWriteBatchedInserts=true`, the JDBC driver will rewrite batch inserts as multi-line inserts in a way that limits the number of calls to the database. For example, the driver changes batch inserts from: insert into foo (col1, col2, col3) values (1,2,3); insert into foo (col1, col2, col3) values (4,5,6); Into: insert into foo (col1, col2, col3) values (1,2,3), (4,5,6); When used correctly, `reWriteBatchedInserts` can improve batch insert performance by as much as 2-3x. Vlad Mihalcea also wrote [more about `reWriteBatchedInserts`](https://vladmihalcea.com/postgresql-multi-row-insert-rewritebatchedinserts-property/) last year if you want a more extended example. This week’s tip is sponsored by [Cockroach Labs](https://www.cockroachlabs.com/?utm_campaign=cooperpress-2020-Q4&utm_source=postgresweekly&utm_medium=sponsor&utm_content=tip-of-the-week-batch-inserts), Learn about CockroachDB in this demo: [“Distributed SQL: a modern, cloud-native PostgreSQL.”](https://www.cockroachlabs.com/webinars/distributed-sql-a-modern-cloud-native-postgresql-thank-you?utm_campaign=cooperpress-2020-Q4&utm_source=postgresweekly&utm_medium=sponsor&utm_content=tip-of-the-week-batch-inserts) **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! --- **Want to sponsor?** Email `[kristina@cooperpress.com](mailto:kristina@cooperpress.com)` for details. --- **Want more?** You might like [DB Weekly](https://dbweekly.com/?utm_source=pg&utm_medium=email&utm_campaign=footer-promo), our more general database newsletter covering data storage trends, new database types, and more. --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom [Stop getting this newsletter.](https://postgresweekly.com/leave/*|UID|*)