--- title: "psql + gnuplot = CLI Graphs From Your Data" publication: "Postgres Weekly" issue: 342 published_at: "2020-02-12" canonical_url: "https://postgresweekly.com/issues/342" --- This week's Postgres news, views, and tools. #342 — February 12, 2020 [Read on the Web](https://postgresweekly.com/issues/342) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/vkvxgzqqrby3afyuozve.jpg)](http://okbob.blogspot.com/2020/02/psql-and-gnuplot.html) [`psql` + `gnuplot` = Command Line Graphs From Your Data](http://okbob.blogspot.com/2020/02/psql-and-gnuplot.html) — [gnuplot](http://www.gnuplot.info/) is a command line graphing program and you can feed `psql` output directly into it to create neat command line based plots. There’s not a lot to see here, but this technique could be useful to you or inspire other ideas. Pavel Stěhule [`psql` in Postgres 13 to Support Showing Transaction Status](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=dcdbb5a5db09064ac08ff3971c5031281ef2e545#prompt) — The prompts in Postgres 13’s version of `psql` will show whether the current connection is in a transaction block or not. Michael Paquier [![\](https://copm.s3.amazonaws.com/cddd609a.png)](https://pganalyze.com/blog/automated-postgres-explain-plan-visualization-and-insights?utm_source=PostgresWeeklyPrimary) [Get Deeper Insights into Your DB with Automated EXPLAIN Plan Analysis](https://pganalyze.com/blog/automated-postgres-explain-plan-visualization-and-insights?utm_source=PostgresWeeklyPrimary) — Other tools might show what happened in the database, pganalyze equips engineering teams with the insights to understand why it happened. Check out our new EXPLAIN insights features to get simple visualizations of costliest plan nodes, slow sorts, and more. pganalyze sponsor [Configuring `work_mem` in Postgres](https://www.pgmustard.com/blog/work-mem) — `work_mem` is the amount of memory used for internal sort operations and hash tables before using temporary disk files instead and is set at just 4MB by default. David Conlin [Aurora PostgreSQL Now Supports Machine Learning and Exporting to Amazon S3](https://aws.amazon.com/about-aws/whats-new/2020/02/aurora-postgresql-supports-machine-learning-export-to-amazon-s3-and-new-minor-versions/) — Several bits of news out of AWS this week for both Aurora (their Postgres-_compatible_ RDBMS) and RDS (actual Postgres on AWS infrastructure). Aurora PostgreSQL can now integrate with AWS’s [SageMaker](https://aws.amazon.com/sagemaker/) machine learning service, you can export data directly into S3, and there’s improved Postgres 11.6 compatibility. Amazon Web Services [Amazon RDS for PostgreSQL Supports New Versions and Instance Sizes](https://aws.amazon.com/about-aws/whats-new/2020/02/amazon-rds-for-postgresql-supports-new-minor-versions-116-1011-9616-9520/) — More AWS news, this time for RDS. As well as support for Postgres 11.6, 10.11, 9.6.16, and 9.5.20, you can now use RDS on [more instance types](https://aws.amazon.com/about-aws/whats-new/2020/02/amazon-rds-for-postgresql-now-supports-additional-sizes-for-dbm5-dbr5-instance-classes/) (db.m5 and db.r5 8xlarge and 16xlarge sizes) if you really need 512GB or RAM on your Postgres instance :-) Amazon Web Services [Why Does Dropping a Column Not Reclaim Disk Space?](https://fluca1978.github.io/2020/02/09/PostgreSQLDROPCOlumn.html) — In short, because it’s not usually necessary. A column is simply made ‘invisible’ to SQL operations and space will be reclaimed over time. Luca Ferrari [How To Migrate From Trigger-Based Partitioning to Native](https://info.crunchydata.com/blog/how-to-migrate-from-trigger-based-partitioning-to-native-in-postgresql) Keith Fiske [An Introduction to Aurora PostgreSQL Cluster Cache Management](https://aws.amazon.com/blogs/database/introduction-to-aurora-postgresql-cluster-cache-management/) — Cluster cache management is a feature available on AWS’s Aurora Postgres variant that helps reduce the negative performance effects of lost/cold caches after failovers. Sameer Malik and Andrei Ilyashenko [Dealing with Casing When Migrating from SQL Server to Postgres](https://www.cybertec-postgresql.com/en/migrating-from-ms-sql-to-postgresql-uppercase-vs-lowercase/) — SQL Server and Postgres have rather different approaches to the use of upper-case letters when naming things. Hans-Jürgen Schönig [Save Time with Postgres Cheatsheet](http://bit.ly/38aX9wg) — Assembled with ❤️ by [Timescale](http://bit.ly/2GYHV14) developers, Postgres Cheatsheet is a one-stop shop for essential Postgres commands. Click, copy, done. Timescale sponsor [How to Map a Postgres Array to a Java List with JPA and Hibernate](https://vladmihalcea.com/postgresql-array-java-list/) Vlad Mihalcea [es2postgres: An ElasticSearch to Postgres Loader](https://github.com/tibkiss/es2postgres) — Uses `es2csv`, `xsv`, `sed` and `psql` to periodically move data from Elasticsearch into Postgres. Tibor Kiss [Hasql: A Flexible Postgres Driver for Haskell](https://github.com/nikita-volkov/hasql) — Boasts a ‘flexible mapping API’ for mapping table data to values in the language. Nikita Volkov 🗓**Upcoming Events** - [PgConf India](https://pgconf.in/conferences/pgconfin2020) (Febuary 26-28 in Bengaluru, India) — A dedicated training day and a multi-track two-day conference. - [Postgres Conference 2020](https://postgresconf.org/conferences/2020) (March 23-27 in New York, United States) — A broad and large scale (indeed, the largest, they say) Postgres event. - [Nordic PgDay 2020](https://2020.nordicpgday.org/) (March 24 in Helsinki, Finland) - [pgDay Paris 2020](https://2020.pgday.paris/#%2319) (March 26 in Paris, France) — [The schedule for this event](https://www.postgresql.eu/events/pgdayparis2020/schedule/) is now available. - [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. As seen on Twitter.. [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/v1581434333/fdhcnkqmmhzsssahowmp.png)](https://twitter.com/lukaseder/status/1226804513069260800) Fingers crossed it's a yes ;-) 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