--- title: "The state of Postgres survey results are in" publication: "Postgres Weekly" issue: 406 published_at: "2021-05-19" canonical_url: "https://postgresweekly.com/issues/406" --- Plus Postgres 13.3, 12.7 and other releases, a Postgres video series on YouTube, and more. | #​406 — May 19, 2021 [Web Version](https://postgresweekly.com/issues/406) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/aqkusmfbpbimyreqevdc.jpg)](https://www.timescale.com/state-of-postgres-results) [The State of Postgres 2021 Results](https://www.timescale.com/state-of-postgres-results) — Recently, Timescale, the folks behind the [TimescaleDB](https://github.com/timescale/timescaledb) Postgres extension, ran a survey to get an idea of the 'state' of the Postgres community. As promised, they've shared the results (including the raw, anonymized data, if you want to do your own analysis) and while the number of respondents wasn't particularly high, some [interesting results](https://blog.timescale.com/blog/2021-state-of-postgres-survey-results/) came of it: - The majority of users call it "Postgres" not "PostgreSQL." - Most respondents are self-managing their Postgres installations. - AWS is by far the most popular cloud amongt users with GCP in a distant second place. - [pgAdmin 4](https://www.pgadmin.org/) is the most heavily used third party tool for working with Postgres. Timescale [![\](https://copm.s3.amazonaws.com/8f9b4cb7.jpeg)](https://www.influxdata.com/influxdb-templates/postgres-monitor/?utm_source=vendor&utm_medium=referral&utm_campaign=2021-05-19_spnsr-nl_postgres-template_global&utm_content=postgres) [PostgreSQL Database Monitoring Dashboard](https://www.influxdata.com/influxdb-templates/postgres-monitor/?utm_source=vendor&utm_medium=referral&utm_campaign=2021-05-19_spnsr-nl_postgres-template_global&utm_content=postgres) — Collect metrics about the performance of your PostgreSQL database — like IO wait, CPU, Data Used, Disk Read time, Disk Write time — with this InfluxDB template. Try it for free with an InfluxDB Cloud account. InfluxData sponsor [Postgres 13.3, 12.7, 11.12, 10.17, and 9.6.22 Released](https://www.postgresql.org/about/news/postgresql-133-127-1112-1017-and-9622-released-2210/) — Yes, it’s the full array of updates for all maintained lines of Postgres. Why? Beyond the usual bug fixes, there are three security vulnerabilities that needed resolving including a buffer overrun in array subscripting calculations, and memory disclosure issues with `INSERT .. ON CONFLICT ... DO UPDATE` and `UPDATE ... RETURNING` queries in certain situations. PostgreSQL News ▶[Postgres Pulse: A 14-Video Series on Postgres Topics](https://www.youtube.com/playlist?list=PLownlFUq_rL6txMapX6UUuquqGdUINmkd#postgrespulse) — If you’ve got some time on your hands, you could do worse than to check out EDB’s videos covering a variety of Postgres topics from [fixing LDAP auth problems](https://www.youtube.com/watch?v=9K7BT5l1Ekk&list=PLownlFUq_rL6txMapX6UUuquqGdUINmkd&index=4) or [using synchronous replication](https://www.youtube.com/watch?v=wLJvw5blCo8&list=PLownlFUq_rL6txMapX6UUuquqGdUINmkd&index=12) to [a look into EXPLAIN ANALYZE](https://www.youtube.com/watch?v=pFSmxnh-K0Y&list=PLownlFUq_rL6txMapX6UUuquqGdUINmkd&index=7) or [reducing database bloat.](https://www.youtube.com/watch?v=9SGU6k8DkHU&list=PLownlFUq_rL6txMapX6UUuquqGdUINmkd&index=2) Various Speakers **PSA:** Three years ago we linked to [annotated.conf](https://github.com/jberkus/annotated.conf), a handy collection of annotations for all of `postgres.conf`'s hundreds of settings. Now it needs to be updated to Postgres 13 standards, but the original creator is no longer in the space. Pull requests are encouraged if you can help. _(The project is still useful as is, of course.)_ [Debugging Random Slow Writes in Postgres](https://iamsafts.com/posts/postgres-gin-performance/) — An interesting look at stepping through a problem and figuring out which settings needed to be tweaked, and how. Sergios Aftsidis [Blog Post: Running a Safe Database Migration Using Postgres](https://retool.com/blog/running-safe-database-migrations-using-postgres/?ref=cooperpress) — A recent database migration took us down for 2 minutes. Learn what happened and how to avoid the same mistake. Retool sponsor [Another Postgres 14 Highlight: `CREATE TABLE COMPRESSION`](https://paquier.xyz/postgresql-2/postgres-14-table-compression/) — The forthcoming Postgres 14 will have an option to let you optionally specify a different form of [TOAST](https://www.postgresql.org/docs/9.5/storage-toast.html) compression for oversized columns. Michael Paquier [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/vanqpuihnkutqcdvb5bl.jpg)](https://akorotkov.github.io/blog/2021/05/17/rainbow-psql-output/) [Rainbow-Color Your `psql` Output](https://akorotkov.github.io/blog/2021/05/17/rainbow-psql-output/) — If you want to show a little pride in your `psql` setup and you have a terminal that can support true color, here’s a fun solution for macOS and Linux. Alexander Korotkov supported by [![CYBERTEC\](https://res.cloudinary.com/cpress/image/upload/v1618830466/ynniwgesklauqe9qwpuz.png)](https://www.cybertec-postgresql.com/) 💡**Tip of the Week** Spotting performance problems quickly Are you looking for performance problems on your server? Consider checking out [pg_stat_statements.](https://www.cybertec-postgresql.com/en/postgresql-detecting-slow-queries-quickly/) It offers a fast and efficient way to look for slow queries. `pg_stat_statements` is a module that comes with Postgres but needs to be specifically loaded by adding the following line to `postgresql.conf`: shared_preload_libraries = 'pg_stat_statements'; Then restart your server and run: CREATE EXTENSION pg_stat_statements; The `pg_stat_statements` system view will provide you with all the relevant information. You can learn more about how to do this and how to spot performance problems in our blog post “[PostgreSQL: Detecting slow queries quickly](https://www.cybertec-postgresql.com/en/postgresql-detecting-slow-queries-quickly/)”. This tip of the week is brought to you by [CYBERTEC](https://www.cybertec-postgresql.com/), your professional partner for PostgreSQL and Data Science since 2000. [Read more](https://www.cybertec-postgresql.com/en/?s=postgresql+performance) about PostgreSQL Performance in CYBERTEC’s blog. **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 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 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|*)