--- title: "Comparing the ways to store binary data with Postgres" publication: "Postgres Weekly" issue: 356 published_at: "2020-05-20" canonical_url: "https://postgresweekly.com/issues/356" --- This week's Postgres news, views, and tools. #356 — May 20, 2020 [Read on the Web](https://postgresweekly.com/issues/356) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/trdeh6ti1iqqeush4gxh.jpg)](https://www.cybertec-postgresql.com/en/binary-data-performance-in-postgresql/) [Comparing Binary Data Performance in Postgres](https://www.cybertec-postgresql.com/en/binary-data-performance-in-postgresql/) — You can store large binary blogs outside your database and reference them, store them as ‘large objects’, or use [bytea](https://www.postgresql.org/docs/9.0/datatype-binary.html) byte arrays. How do they compare? This is an important thing to consider if you do have binary blobs flying around in your data model. BTW, I’m loving Laurenz’s lo-fi post illustrations lately 😂 Laurenz Albe [The Draft Postgres 13 Release Notes](https://www.postgresql.org/docs/devel/release-13.html) — As Bruce Momjian [wrote](https://momjian.us/main/blogs/pgblog/2020.html#May_15_2020): _“I have completed the draft version of the Postgres 13 release notes, containing 181 items. The release notes will be continually updated until the final release, which is expected to be in September or October of this year.”_ PostgreSQL Global Development Group [![\](https://copm.s3.amazonaws.com/ed0b0e12.png)](https://www.2ndquadrant.com/en/resources/kubernetes-operators-for-highly-available-postgresql-and-bdr/) [Kubernetes Operators for Highly Available PostgreSQL and BDR](https://www.2ndquadrant.com/en/resources/kubernetes-operators-for-highly-available-postgresql-and-bdr/) — Ground-breaking design with up to 7x faster performance and negligible overhead on bare metal; easy setup and superior user experience. Developed for mission critical databases with high security requirements. Backed by 24/7 Support for production use. 2ndQuadrant PostgreSQL Products sponsor [PostgreSQL 12.3, 11.8, 10.13, 9.6.18, and 9.5.22 Released](https://www.postgresql.org/about/news/2038/) — Fixes 75 bugs reported since the last mass release, but one key Windows-only security issue. PostgreSQL Global Development Group ▶[Discussing Index Corruption in Postgres](https://www.youtube.com/watch?v=J0zsZRyPuow) — Two developers at EnterpriseDB discuss database corruption and how corrupt _indexes_ are not always as obvious as corrupt _tables_. Postgres Pulse [How to Count Hits on a Web Site in Postgres](https://www.cybertec-postgresql.com/en/how-to-count-hits-on-a-website-in-postgresql/) — If you want to be accurate, it’s all matter of handling concurrency. A rather elaborate solution is on offer here. Hans-Jürgen Schönig [An Interview with Dimitri Fontaine](https://postgresql.life/post/dimitri_fontaine/) — Dimitri, of [The Art of PostgreSQL](https://theartofpostgresql.com/) fame, is this person’s _PostgreSQL Person of the Week_ and faces the usual questions about his work with Postgres, his top Postgres annoyance, etc. Andreas Scherbaum [Building PostgreSQL and Extensions on Windows from Scratch](https://www.highgo.ca/2020/05/15/build-postgresql-and-extension-on-windows/) — Yep, you can compile Postgres and extensions using Visual Studio 2019. Here’s how. David Zhang [Free eBook: How to Get a 3x Performance Improvement on Your Postgres Database](https://pganalyze.com/ebooks/optimizing-postgres-query-performance?utm_source=PostgresWeeklySecondary05202020) — Learn our best practices for optimizing Postgres query performance for customers like Atlassian and how to reduce data loaded from disk by 500x. pganalyze sponsor ▶[Powering Up Postgres Analytics with Swarm64](https://www.dataengineeringpodcast.com/swarm64-postgresql-analytics-episode-133/) — A few weeks ago we featured news about [Swarm64](https://www.datanami.com/2020/04/27/postgresql-gets-a-parallel-processing-boost/), a Postgres “acceleration” system. This podcast interviews Swarm64 CEO Thomas Richter about optimizing Postgres on high performance hardware and even FPGAs for analytical workloads. The Data Engineering Podcast podcast [How to Use pgBadger to Solve Query Performance Issues](https://www.enterprisedb.com/blog/how-to-use-pgbadger-log-analyzer-postgresql-query-performance) — [pgBadger](https://github.com/darold/pgbadger) is a Postgres log analyzer which you can use to surface data about where your Postgres server is running into performance issues. Mohini Ogale and Amit Sharma [Using MQTT as a Transport for Postgres Messages](https://theplateisbad.blogspot.com/2020/05/mqtt-as-transport-for-postgresql-events.html) — MQTT has become a de-facto standard for the transport of messages between IoT devices. ergo 🗓**Upcoming Online Events** - [Postgres Pulse](https://www.enterprisedb.com/postgres-pulse) - weekly at 11am ET each Monday. Weekly Zoom-based sessions with folks like Bruce Momjian, Vibhor Kumar, and other people at EnterpriseDB. - [Postgres Vision 2020](https://www.postgresvision.com/) on June 23-24. A full attempt at an online Postgres conference across multiple days with multiple tracks. 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