#213: Dexter - An Automatic Indexer for Postgres

.

Read this on the Web

Postgres Weekly Issue 213 — June 28, 2017

Introducing Dexter: An Automatic Indexer for Postgres By monitoring queries, this tool will generate queries to improve their performance. Andrew Kane Partitioning Existing Tables in Postgres Options for partitioning existing production Postgres tables, and trade-offs to consider. Igor Stojkovic Mitigate Risk. Evaluate BEFORE you Migrate with a 2ndQuadrant Migration Assessment. Get an upfront evaluation of what will be required for a smooth migration without loss of data, unplanned downtime or unexpected expenses. A PostgreSQL Migration Assessment can help mitigate risk, identify blockers, & estimate effort and cost. 2ndQuadrant PostgreSQL Services    #sponsored  A Look at Postgres’s LATERAL JOIN PostgreSQL 9.3 introduced a new kind of join that can run a subquery over each result from another table or subquery. Krzysztof Kempiński Building SQL Queries for Funnel Analysis How Statsbot constructs SQL queries for conversion funnel analysis. Nurzhan Ospanov Postgres 10 Beta vs Postgres 9.6 Analytics Performance How does the latest version of Postgres, still in beta, fare performance-wise? Kaarel Moppel   #opinion  PgBackMan 1.2.0: A Tool for Logical Backup Management A tool for managing PostgreSQL logical backups created with pg_dump and pg_dumpall. Rafael Martinez Guerrero   #tools  PostgreSQL in a Time of Kubernetes Zalando has released an operator tool to help manage Postgres clusters in Kubernetes. Zalando   #tools  Real-time Postgres performance monitoring Graph and correlate 50+ Postgres metrics with data from the rest of your infrastructure & apps. 14-day free trial. Datadog    #sponsored  pg-amqp-bridge: Send Messages to RabbitMQ from Postgres Put a row into a table and get a message sent to RabbitMQ. Ideal for more decoupling in your apps. subZero   #code  pREST: Serve a RESTful API from any Postgres Database Written in Go. Nuveo   #code  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