---
title: "Amazon RDS now lets you take Postgres from outhouse to inhouse"
publication: "Postgres Weekly"
issue: 363
published_at: "2020-07-08"
canonical_url: "https://postgresweekly.com/issues/363"
---

Plus creating your own data types and a harmful workload generator to stress test Postgres.       

#363 — July 8, 2020 

[Web Version](https://postgresweekly.com/issues/363)   

Postgres Weekly 

[![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/v1593533532/n1oxkrkkiu4xysoxgtav.jpg)](https://pgsnake.blogspot.com/2020/06/systemstats-extension-for-postgresql.html)   

[Using the `system_stats` Extension to Monitor Postgres](https://pgsnake.blogspot.com/2020/06/systemstats-extension-for-postgresql.html) — [system_stats](https://github.com/EnterpriseDB/system_stats) is a new extension (out of EDB, formerly EnterpriseDB) made up of several stored procedures you can use to monitor Postgres (or, more accurately, the server it’s running on). 

Dave Page   

[Generating Random Strings and Integers That Actually Aren’t](https://www.endpoint.com/blog/2020/07/02/random-strings-and-integers-that-actually-arent) — A look at creating “random-looking” coupon codes or similar strings in a PL/pgSQL function. 

Josh Williams   [![\](https://copm.s3.amazonaws.com/7f857dae.png)](https://pganalyze.com/ebooks/optimizing-postgres-query-performance?utm_source=PostgresWeeklyPrimary07082020) 

[We’ve Helped 100s of Customers Speed Up Postgres. Learn Our Best Practices](https://pganalyze.com/ebooks/optimizing-postgres-query-performance?utm_source=PostgresWeeklyPrimary07082020) — With pganalyze, companies like Robinhood are able to speed up their queries by orders of magnitude. In this ebook, we share our best practices for optimizing Postgres performance. 

pganalyze sponsor   

[Bitnine Looks to Scale Postgres with AGE](https://www.datanami.com/2020/06/30/bitnine-looks-to-scale-postgresql/) — [AgensGraph](https://github.com/bitnine-oss/agensgraph) is a transactional graph database built on Postgres but has now morphed into a new project called [AGE](https://github.com/bitnine-oss/AgensGraph-Extension) and is being incubated by Apache. 

Datanami   

[Amazon RDS Now Works on AWS Outposts](https://aws.amazon.com/about-aws/whats-new/2020/07/aws-announced-amazon-relational-database-service-support-mysql-postgresql-databases-aws-outposts/) — Let’s untangle this. [RDS (Relational Database Service)](https://aws.amazon.com/rds/) is AWS’s service for running Postgres (and MySQL) in the cloud. [AWS Outpost](https://aws.amazon.com/outposts/) is a way to take the AWS experience into your own datacenter. So now you can use AWS’s cloud database service on AWS’s hardware but within your own physical environment. OK - got it! 

AWS   

[Using `CREATE DOMAIN` to Create New Data Types](https://www.cybertec-postgresql.com/en/postgresql-useful-new-data-types/) — If you want to create more advanced server side data type constraints than the default data types can provide, you can create your own data types ([domains](https://www.postgresql.org/docs/9.5/sql-createdomain.html)). 

Hans-Jürgen Schönig   

[Generated Columns vs. Triggers in Postgres 12](https://www.ongres.com/blog/generate_columns_vs_triggers/) — Postgres 12 introduced the idea of [generated columns](https://www.postgresql.org/docs/12/ddl-generated-columns.html) - columns which are generated from other columns’ values. This post compares the performance against using triggers to similar ends. 

Emanuel Calvo and Anthony Sotolongo   

[More Postgres 13 Features: Deduplication in B-Tree Indexes](https://www.highgo.ca/2020/07/06/features-in-pg13-deduplication-in-b-tree-indexes/) — Postgres 13, due later this year, has a feature that can decrease the size of B-tree indexes by way of avoiding duplication. This post includes a contrived example to show off the difference. 

Hamid Akhtar   

[Enterprise-Ready PostgreSQL | EDB Supercharges PostgreSQL](https://www.enterprisedb.com/?utm_source=Cooperpress&utm_medium=ad) — A portfolio of service offerings to help you on your PostgreSQL journey. Data migration. Hybrid cloud. High availability. 

EDB sponsor   

[How Storj Migrated from Postgres to CockroachDB: Bulk Loading Performance](https://dzone.com/articles/how-storj-is-migrating-from-postgres-to-cockroachd) 

Jessica Grebenschikov   

[plpgsql_check: A PL/pgSQL Code Checker](https://github.com/okbob/plpgsql_check) — A specialized tool for when you want to find any errors lurking in your PL/pgSQL functions. Support for functions with arguments of [polymorphic types](https://www.postgresql.org/docs/current/extend-type-system.html#EXTEND-TYPES-POLYMORPHIC) has just [been added.](https://github.com/okbob/plpgsql_check/releases/tag/v1.11.0) 

Pavel Stehule   

[Noisia: A 'Harmful Workload Generator' for Postgres](https://github.com/lesovsky/noisia) — Creates things like deadlocks, transactions that do nothing and queries that produce on-disk temporary files. Why? For testing, stress-testing your setup, etc. Use carefully and with caution. 

Lesovsky Alexey         

Curated by [Cooperpress](https://cooperpress.com/), [Peter Cooper](https://twitter.com/peterc), and [Craig Kerstiens](https://twitter.com/craigkerstiens). 

[Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom