---
title: "#213: Dexter - An Automatic Indexer for Postgres"
publication: "Postgres Weekly"
issue: 213
published_at: "2017-06-28"
canonical_url: "https://postgresweekly.com/issues/213"
---

Postgres Weekly 213   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 213 — June 28, 2017     

[Introducing Dexter: An Automatic Indexer for Postgres](https://medium.com/@ankane/introducing-dexter-the-automatic-indexer-for-postgres-5f8fa8b28f27?utm_source=postgresweekly&utm_medium=email)By monitoring queries, this tool will generate queries to improve their performance. Andrew Kane [Partitioning Existing Tables in Postgres](http://blog.nordeus.com/dev-ops/partitioning-existing-tables-in-postgresql.htm?utm_source=postgresweekly&utm_medium=email)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.](https://www.2ndquadrant.com/en/services/postgresql-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[![\](https://copm.s3.amazonaws.com/2964fb92.png)](https://www.2ndquadrant.com/en/services/postgresql-migration-assessment/) [A Look at Postgres’s LATERAL JOIN](https://medium.com/kkempin/postgresqls-lateral-join-bfd6bd0199df?utm_source=postgresweekly&utm_medium=email)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](https://blog.statsbot.co/sql-queries-for-funnel-analysis-35d5e456371d?utm_source=postgresweekly&utm_medium=email)How Statsbot constructs SQL queries for conversion funnel analysis. Nurzhan Ospanov [Postgres 10 Beta vs Postgres 9.6 Analytics Performance](http://www.cybertec.at/a-quick-check-on-postgres-10-beta-analytics-performance-vs-version-9-6/?utm_source=postgresweekly&utm_medium=email)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](https://www.postgresql.org/about/news/1759/?utm_source=postgresweekly&utm_medium=email)A tool for managing PostgreSQL logical backups created with pg_dump and pg_dumpall. Rafael Martinez Guerrero#tools [PostgreSQL in a Time of Kubernetes](https://tech.zalando.com/blog/postgresql-in-a-time-of-kubernetes/?utm_source=postgresweekly&utm_medium=email)Zalando has released an [operator tool](https://github.com/zalando-incubator/postgres-operator) to help manage Postgres clusters in Kubernetes. Zalando#tools [Real-time Postgres performance monitoring](https://www.datadoghq.com/lpgpts2/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyS)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](https://github.com/subzerocloud/pg-amqp-bridge?utm_source=postgresweekly&utm_medium=email)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](https://github.com/nuveo/prest?utm_source=postgresweekly&utm_medium=email)Written in Go. Nuveo#code    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/213) [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