---
title: "#240: Experiences with Running Postgres on Kubernetes"
publication: "Postgres Weekly"
issue: 240
published_at: "2018-01-24"
canonical_url: "https://postgresweekly.com/issues/240"
---

Postgres Weekly 240   . 

[Read this on the Web](http://postgresweekly.com/issues/240) 

[Postgres Weekly](http://postgresweekly.com) Issue 240 — January 24, 2018     

[Interactive Postgres Configuration Generator](http://pgconfigurator.cybertec.at/)An interesting tool where you select things like how many CPUs and how much memory your database server has and an optimized config file is created. Hans-Juergen Schoenig#tools [Experiences with Running Postgres on Kubernetes](https://gravitational.com/blog/running-postgresql-on-kubernetes/)A transcript of an interview focusing on the challenges involved in running Postgres on Kubernetes, along with useful approaches. Abraham Ingersoll [Turn Database Monitoring Information into Insight](https://selectstar.io/better-insights/?utm_source=CooperPress&utm_medium=Primary&utm_campaign=Postgres+Weekly+Primary+Link+Jan24)SelectStar is the only database monitoring solution that digs deep into today’s modern data tier to provide recommendations, including those that may increase query speeds and even close security holes. If you liked what you see, you can take action immediately with a single click. SelectStar#sponsored[![\](https://copm.s3.amazonaws.com/81e235cf.png)](https://selectstar.io/better-insights/?utm_source=CooperPress&utm_medium=Primary&utm_campaign=Postgres+Weekly+Primary+Link+Jan24) [Migrating MySQL to Postgres with Minimal Downtime](http://www.pgdba.co.uk/2018/01/migrating-mysql-to-postgresql-with.html)Looking to migrate from MySQL to Postgres and minimize your downtime? pg_chameleon is a tool that can help by replicating from MySQL to Postgres. Federico Campoli [Heroku Postgres PGX: Better Infrastructure for PostgreSQL](https://blog.heroku.com/heroku-pgx-plans)Exciting news for Heroku users as a new version of their Postgres platform is unveiled offering a lot more for the same rates as before. Migration is necessary, however. Heroku#news [Postgres 11 To Support Indexes on Partitioned Tables](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=8b08f7d4820fd7a8ef6152a9dd8c6e3cb01e5f9)The first beta of Postgres 11 isn’t due till later in the year, but support has just been added for creating indexes on partitioned tables (as introduced in Postgres 10). Álvaro Herrera#news [Creating Partitions of Partitions with Postgres 10](https://joaodlf.com/postgresql-10-partitions-of-partitions.html) João Ferreira [Upgrading the Version of a Heroku Postgres Database](https://devcenter.heroku.com/articles/upgrading-heroku-postgres-databases)With Postgres 10 now out, it’s worth upgrading, and if you’re a Heroku user, here are the steps to take. Heroku Dev Center [Replication Topologies in Postgres](https://www.opsdash.com/blog/postgresql-replication-topologies.html)The various ways to use Postgres’s ability to replicate data across multiple machines. OpsDash [Create Trigram Indexes with pg_trgm](https://www.postgresql.org/docs/current/static/pgtrgm.html)Trigram indexes are particularly useful for speeding up wildcard queries, such as `field LIKE '%something%'` PostgreSQL Documentation [Multi-Tenant Webapps with ASP.NET Core and Postgres](https://www.citusdata.com/blog/2018/01/22/multi-tenant-web-apps-with-dot-net-core-and-postgres/)ASP.NET is growing beyond its SQL Server roots. If you’re building a multi-tenant app with ASP.NET, here’s a step by step walkthrough using Citus and Postgres. citusdata [Full Stack Postgres Consulting, Remote DBA, Training, and 24/7 Support](https://commandprompt.com/) Command Prompt, Inc.​ #sponsored    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/240) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK