--- title: "The state of Postgres survey results are in" publication: "Postgres Weekly" issue: 335 published_at: "2019-12-11" canonical_url: "https://postgresweekly.com/issues/335" --- This week's PostgreSQL news and tutorials. #335 — December 11, 2019 [Read on the Web](https://postgresweekly.com/issues/335) Did you know two thirds of Postgres users have never attended a Postgres-related event? If you want to change this, our events listing section at the end of each issue is now even larger :-) Check it out. Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/v1576005477/j9xwnk9klmkl9li75ba1.png)](https://github.com/yandex/odyssey) [Odyssey 1.0: A Scalable Postgres Connection Pooler](https://github.com/yandex/odyssey) — Yandex has just released version 1.0 of their multi-threaded connection pooler and request router. _“We are using Odyssey in production. Currently, it handles more than 1,000,000 requests per second on many hundreds of hosts.”_ Yandex [Postgres at a Low Level: Stay Curious](https://erthalion.info/2019/12/06/postgresql-stay-curious/) — A meaty post that’s a sort of grab-bag of interesting low level bits and pieces that you might find interesting (but are not particularly _essential_). Swerves between topics including buffering, BPF, and IO scheduling. Dmitry Dolgov [![\](https://copm.s3.amazonaws.com/21a1fb6e.png)](https://pgexperts.com/) [Your Data Is Your Business](https://pgexperts.com/) — PGX is a full-service database consultancy focused around PostgreSQL systems. Let us help you architect, build, troubleshoot and scale your PostgreSQL data systems on any platform or hosting environment. PostgreSQL Experts, Inc. sponsor [The State of PostgreSQL Survey Results](https://stateofpostgres.com/) — We encouraged you to fill out this Postgres survey a few months ago and.. about 500 people did. Half of respondents are using Postgres on AWS, 80% are using Postgres _outside_ of work too, and most of us haven’t ever attended a real life Postgres event. Robert Treat has some [independent thoughts](https://xzilla.net//blog/2019/Dec/5-Quick-Thoughts-On-The-State-Of-Postgres-Survey.html) on the results. Timescale [PGCon 2020 Call for Papers Now Open](https://www.pgcon.org/2020/papers.php) — PGCon 2020 is taking place in Ottawa, Canada next May. They’re looking for speakers and have a deadline of January 19, 2020 to get your proposal in. There’s a neat list of talk ideas to get you thinking on this page too. PGCon [Amazon Teases a Proxy System for RDS](https://aws.amazon.com/about-aws/whats-new/2019/12/amazon-rds-proxy-available-in-preview/?trk=ls_card) — If you’ve got a _lot_ of processes (or Lambda functions, say) hitting RDS-based databases, this could eventually come in _very_ handy. Currently it’s _MySQL only_ (PostgreSQL support is ‘coming soon’) and in preview only. Amazon Web Services [EnterpriseDB Announces Postgres Platform 12](https://www.enterprisedb.com/news/enterprisedb-announces-postgres-platform-12-extends-leading-open-source-database) — EnterpriseDB offers commercial Postgres distribution with added management tools, Kubernetes operator, etc. EnterpriseDB supported by [![Digital Ocean\](https://res.cloudinary.com/cpress/image/upload/v1570809425/nlqv0ueejagpj7gkft55.png)](https://blog.digitalocean.com/how-we-launched-our-marketplace-using-digitalocean-kubernetes-part-1/?medium=display&utm_source=cooperpress&utm_campaign=MDB_Dev_Signup_Cold_Newsletter12-11-2019) 💡**Tip of the Week** See how `psql`'s commands use SQL behind the scenes When you use `psql`, you are almost certainly using commands like `\dt` to get a list of tables or `\l` to list tables — but how do they work? I've tended to think of such commands as 'magic' since it's easy to assume that `psql` has a view into Postgres that I don't, but under the hood it's actually just issuing SQL queries like any that I might choose to run too. Can we see what these SQL queries are? Yes! `psql` has a `ECHO_HIDDEN` variable you can set to show (or 'echo') any SQL queries performed behind the scenes by backslash commands. Set it like so: \set ECHO_HIDDEN on Then, see what happens when you run a command like `\dl`: **=> \l** ********* QUERY ********** SELECT d.datname as "Name", pg_catalog.pg_get_userbyid(d.datdba) as "Owner", pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding", d.datcollate as "Collate", d.datctype as "Ctype", pg_catalog.array_to_string(d.datacl, E'\n') AS "Access privileges" FROM pg_catalog.pg_database d ORDER BY 1; ************************** ... list of databases follows here as usual ... If you were to copy and paste this query for yourself, you'd get the very same results that `\l` usually does. The practical utility of this tip may seem limited at first, but could help provide you with an understanding of how things are represented behind the scenes, and potentially tweak such queries to better suit your own database interrogation needs. This week’s Tip of the Week is sponsored by [DigitalOcean](https://blog.digitalocean.com/how-we-launched-our-marketplace-using-digitalocean-kubernetes-part-1/?medium=display&utm_source=cooperpress&utm_campaign=MDB_Dev_Signup_Cold_Newsletter12-11-2019). Find out [how engineers at DigitalOcean built a scalable marketplace for developers](https://blog.digitalocean.com/how-we-launched-our-marketplace-using-digitalocean-kubernetes-part-1/?medium=display&utm_source=cooperpress&utm_campaign=MDB_Dev_Signup_Cold_Newsletter12-11-2019) on top of their managed Kubernetes service. 📂**And the rest** [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/suvl4hrdk9fswuqz4jt8.jpg)](https://www.db-fiddle.com/) [DB Fiddle: An SQL Database Playground](https://www.db-fiddle.com/) — I frequently find this tool useful for testing out little bits of SQL. It lets you run basic queries upon several versions of Postgres (including, now, version 12), MySQL, and SQLite, right from your browser. Status200 [Postgres 12's `EXPLAIN SETTINGS`](https://fluca1978.github.io/2019/12/05/Explain_settings.html) — A way to make `EXPLAIN` output more representative of what really happened when settings that affect the query have been changed. Luca Ferrari [Take the Guesswork Out of Improving Query Performance](https://www.pgmustard.com?referrer=postgresweekly) — Based on the query plan, pgMustard offers you tips to make your query faster. Try it for free. pgMustard sponsor [How to Perform a Major Version Upgrade Using `pg_upgrade`](https://info.crunchydata.com/blog/how-to-perform-a-major-version-upgrade-using-pg_upgrade-in-postgresql) James Chanco Jr. [How to Create a Serverless GraphQL API for Postgres and Aurora](https://serverless.com/blog/graphql-api-mysql-postgres-aurora/) — Learn how to build a serverless GraphQL API backed by Postgres (_and_ MySQL) on Amazon’s _Aurora_. Gareth McCumskey [Interesting Aspects of Logical Replication at a Glance](https://rafiasabih.blogspot.com/2019/12/interesting-aspects-of-logical.html) Rafia Sabih [phpPgAdmin 7.12.1 Released](https://xzilla.net//blog/2019/Dec/phpPgAdmin-7-12-1-released.html) — A Web-based administration tool for Postgres. Robert Treat 🗓**Upcoming Events** If you're in the 66% of Postgres users who haven't attended a Postgres event yet, there are lots coming up: - [PgDay SF](https://2020.pgdaysf.org/) (January 21 in San Francisco) — A one-day, single-track event. - [PgDay FOSDEM](https://2020.fosdempgday.org/) (January 31 in Brussels, Belgium) — Not only is there this Postgres event surrounding the popular open source event, but there's a Postgres room at FOSDEM itself on February 2 too. - [PgConf.Russia](https://pgconf.ru/2020) (Febuary 3-5 in Moscow, Russia) — One day of tutorials and two days of talks in three parallel sessions. - [PgConf India](https://pgconf.in/conferences/pgconfin2020) (Febuary 26-28 in Bengaluru, Maharashtra, India) — A dedicated training day and a multi-track two-day conference. - [Nordic PgDay 2020](https://2020.nordicpgday.org/) (March 24 in Helsinki, Finland) — Their CFP is only open till the end of the month so be quick. - [pgDay Paris 2020](https://2020.pgday.paris/#%2319) (March 26 in Paris, France) — Learn more about the world’s most advanced open source database among your peers. - [Swiss PGDay 2020](http://www.pgday.ch/2020/) (June 18-19 in Switzerland) — A two track conference (one in English, one in German) aimed at the entire Postgres community. If you are running a Postgres related event that's beyond the scale of a small local meetup or user group (so, say, 50+ people with people likely to travel to your event from afar), let us know and we can include it here in future issues. 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