#240: Experiences with Running Postgres on Kubernetes

.

Read this on the Web

Postgres Weekly Issue 240 — January 24, 2018

Interactive Postgres Configuration Generator 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 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 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  Migrating MySQL to Postgres with Minimal Downtime 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 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 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 João Ferreira Upgrading the Version of a Heroku Postgres Database 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 The various ways to use Postgres’s ability to replicate data across multiple machines. OpsDash Create Trigram Indexes with pg_trgm 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 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 Command Prompt, Inc.​    #sponsored  Postgres Weekly is curated by Craig Kerstiens Read this issue on the Web See our archives Change your email address Stop getting this newsletter Published by Cooperpress Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK