---
title: "#235: Postgres 11 Adding Support for 'SQL Procedures"
publication: "Postgres Weekly"
issue: 235
published_at: "2017-12-06"
canonical_url: "https://postgresweekly.com/issues/235"
---

Postgres Weekly 235   . 

[Read this on the Web](http://postgresweekly.com/issues/235) 

[Postgres Weekly](http://postgresweekly.com) Issue 235 — December 6, 2017     

[Postgres 11 Adding Support for 'SQL Procedures'](https://www.postgresql.org/message-id/E1eKRgh-0000CR-1U@gemulon.postgresql.org)Work on the next major version of Postgres is ongoing and the latest addition is support for SQL procedures, as supported in Oracle and SQL Server. Peter Eisentraut#news [Analyzing Millions of Postgres Query Plans](https://blog.heapanalytics.com/analyzing-performance-millions-sql-queries-one-special-snowflake/)Analytics tool Heap handles a dynamic schema that isn’t fully known until read time. Here’s how they use Postgres extension `auto_explain` for figuring out why _any_ queries are slow. Michael Malis [Demystifying Postgres Logical Replication](https://learn.percona.com/cp-demystifying-postgres-logical-replication-recording)Logical decoding was added in Postgres 9.4, and it continues to improve due to the vibrant open source community. In this webinar, we'll be walking through its concepts, usage and some of the new things coming in future releases. Percona#sponsored[![\](https://copm.s3.amazonaws.com/141e7b3b.png)](https://learn.percona.com/cp-demystifying-postgres-logical-replication-recording) [Adding a NOT NULL CONSTRAINT on PG Faster with Minimal Locking](https://medium.com/doctolib-engineering/adding-a-not-null-constraint-on-pg-faster-with-minimal-locking-38b2c00c4d1c)Constraints on your data are useful to ensure correctness, but adding them can sometimes come at a cost. This guidance helps makes the process cleaner. Christophe Escobar [PostgreSQL Exercises](https://pgexercises.com/)If you’re looking for a way to practice your SQL skills, PG Exercises offers some good example data and exercises to hone your skills. Alisdair Owens#tools [Amazon RDS Now Supports Database Storage Sizes up to 16TB](https://aws.amazon.com/about-aws/whats-new/2017/11/amazon-rds-now-supports-database-storage-size-up-to-16tb-and-faster-scaling-for-mysql-mariadb-oracle-and-postgresql-engines/)RDS has increased the max storage size from 6 TB now up to 16 TB for a single instance. Amazon Web Services#news [Amazon RDS and Aurora: The Golden Arches of Postgres?](https://medium.com/enterprisedb/amazon-rds-and-aurora-the-golden-arches-of-postgres-258e77cc62d3)_“Amazon RDS and the elasticity of Aurora are great additions to core capabilities of Postgres. But what are the trade-offs for these benefits and how do they affect other Postgres capabilities?”_ Keith Alsheimer, CMO of EnterpriseDB#opinion [Scaling Postgres: Load Balancing and Healthchecks](https://www.thumbtack.com/engineering/scaling-postgresql-load-balancing-healthchecks/)Running your own Postgres database but need some automation around scaling and monitoring? Here’s a look at one setup and how they’ve configured things to keep scaling. Marco Almeida [A Guide for Customer Retention Analysis with SQL](https://blog.statsbot.co/customer-retention-analysis-93af9daee46b)A great run through of some moderately complex, but very useful SQL for analyzing retention data of customers. Luba Belokon [Linux Cloud Hosting Starting at 1GB of RAM for $5/mo](https://welcome.linode.com/postgres-weekly/?utm_source=cooperpress&utm_medium=sponsored&utm_campaign=postgres-weekly-sponsored)Get a Linode server up and running in seconds. Get a $20 credit on a new account. Linode Cloud Hosting#sponsored [pg_hexedit: Rich Hex Editor Annotations for Postgres Relfiles](https://pgeoghegan.blogspot.co.uk/2017/11/pghexedit-rich-hex-editor-annotations.html)An experimental tool for looking at Postgres’ relation files in a hex editor with annotations/tags and tooltips that show what’s going on. Peter Geoghegan#tools [check_pgactivity 2.3: A Postgres Plugin for Nagios](https://github.com/OPMDG/check_pgactivity)Now with complete Postgres 10 support. github.​com#tools    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/235) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK