Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
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 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.