--- title: "How the network can affect query performance" publication: "Postgres Weekly" issue: 418 published_at: "2021-08-11" canonical_url: "https://postgresweekly.com/issues/418" --- Plus we're taking a break next week. | #​418 — August 11, 2021 [Web Version](https://postgresweekly.com/issues/418) 📋 I'm taking a rare vacation next week so Postgres Weekly will be taking a break too :-) I hope your summer (or winter, if you're in the southern hemisphere!) is going well and we'll be back on August 25. __ _Peter Cooper, Editor_ Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/qvdzgew7zremkq8iegut.jpg)](https://www.cybertec-postgresql.com/en/postgresql-grouping-sets-rollup-cube/) [Grouping Sets with `ROLLUP` and `CUBE`](https://www.cybertec-postgresql.com/en/postgresql-grouping-sets-rollup-cube/) — A grouping set is a set of columns used in a `GROUP BY` clause and can come in handy in OLAP queries. This post has some handy examples. Hans-Jürgen Schönig [The Impact of the Network and Cursors on Query Performance](https://www.percona.com/blog/impact-of-network-and-cursor-on-query-performance-of-postgresql/) — Network related overhead isn’t often considered when we think about database or query performance, but it pays to be aware of it. Cursors are also taken into account as they can reduce initial latency on big result sets. Jobin Augustine [![\](https://copm.s3.amazonaws.com/18735702.jpg)](https://www.cybertec-postgresql.com/en/products/postgresql-transparent-data-encryption/) [CYBERTEC TDE: Transparent Data Encryption for PostgreSQL](https://www.cybertec-postgresql.com/en/products/postgresql-transparent-data-encryption/) — TDE is a custom patch to PostgreSQL. It is currently the only implementation that fully supports transparent and cryptographically safe data (cluster) level encryption, independent of operating system or file system encryption. [Download TDE here](https://www.cybertec-postgresql.com/en/products/postgresql-transparent-data-encryption/). CYBERTEC sponsor [Modernizing a Familiar Approach to REST APIs, with Postgres and Cloudflare Workers](https://blog.cloudflare.com/modernizing-a-familiar-approach-to-rest-apis-with-postgresql-and-cloudflare-workers/) — [PostgREST](https://postgrest.org/en/stable/) is a tool that generates a REST API for Postgres databases and here we learn how Cloudflare Tunnel could be used to let _Worker_ instances talk to a PostgREST instance hosted on a private network. Kristian Freeman (Cloudflare) [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/gcyjh2i69o04nyrfkhwt.jpg)](https://fluca1978.github.io/2021/08/07/PostgreSQLLateralJoin.html) [A Simple Example of a LATERAL Join Use Case](https://fluca1978.github.io/2021/08/07/PostgreSQLLateralJoin.html) — A month ago we linked to a piece about [understanding LATERAL joins](https://www.cybertec-postgresql.com/en/understanding-lateral-joins-in-postgresql/) but here’s a practical use case. Luca Ferrari [Citus 10 Now GA in Hyperscale (Citus) for Postgres on Azure](https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/citus-10-is-now-ga-in-hyperscale-citus-for-postgres-on-azure/ba-p/2629932) — One solely for the Azure users among you, but Azure’s own Hyperscale Postgres service now supports the latest Citus release. Nik Larin (Microsoft) ▶[How Citus Distributes PostgreSQL](https://www.youtube.com/watch?v=JwjjUT8K7po) — If you keep seeing references to _Citus_ (as above) but aren’t sure just how it helps distribute Postgres, Marco Slot did a handy talk to bring you up to speed. The slides are really fantastic with lots of diagrams and examples of Citus’s operation. Marco Slot [`postgres_fdw` Enhancements in Postgres 14](https://www.percona.com/blog/2021/06/02/postgres_fdw-enhancement-in-postgresql-14/) — A preview of some of the changes expected in the foreign data wrapper (FDW) for working with data stored in external Postgres servers. Ibrar Ahmed [📈 How to Analyze Intraday Stock Data with Postgres, Python & TimescaleDB](https://tsdb.co/intraday-stock-data-tutorial) Timescale sponsor [Working with Postgres Types](https://blog.jonudell.net/2021/07/27/working-with-postgres-types/) — The author has been experimenting with sharing types between Postgres functions. Jon Udell [10 Common Postgres Errors](https://www.percona.com/blog/2020/06/05/10-common-postgresql-errors/) — Some quick fire common errors and warnings to watch out for, with symptoms and solutions, around things like memory, disk space, and permissions. _(This is an older item but recently popped up on our radar again.)_ Ibrar Ahmed [PureORM: A Node.js SQL Toolkit for Writing Native SQL Queries Yielding Pure Business Objects](https://github.com/craigmichaelmartin/pure-orm) — Allows you to write regular native SQL and receive back properly structured (nested) pure business objects, as opposed to a more typical ORM where you build queries in other ways. Craig Martin 📅 [PGDAY Austria](https://pgday.at/en/) is a Postgres conference taking place in Vienna on September 17, 2021 if you're in that part of the world? **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|*)