---
title: "#210: Scaling Out Complex SQL Transactions in Multi-Tenant Apps"
publication: "Postgres Weekly"
issue: 210
published_at: "2017-06-07"
canonical_url: "https://postgresweekly.com/issues/210"
---

Postgres Weekly 210   . 

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

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

[Scaling Out Complex SQL Transactions in Multi-Tenant Apps](https://www.citusdata.com/blog/2017/06/02/scaling-complex-sql-transactions/?utm_source=postgresweekly&utm_medium=email)Citus is an open source database built on top of Postgres–helping scale out your data. Here they walk through how you can have complex SQL transactions in Citus distributed setup. citusdata [The Postgres Vacuum](http://malisper.me/the-postgres-vacuum/?utm_source=postgresweekly&utm_medium=email)Malis continues his series on all things Postgres. First with this post on 'vacuum' and following it up with some details about [transaction wraparound](http://malisper.me/transaction-id-wraparound-in-postgres/). Michael Malis [check_pgactivity 2.2: A Postgres Plugin for Nagios](https://github.com/OPMDG/check_pgactivity?utm_source=postgresweekly&utm_medium=email)A Nagios-compatible checker to monitor key features of a Postgres cluster such as database size, slow queries, dumps, bloated indexes, and more. PostgreSQL#tools [Why waste time managing your own developer services](https://www.manifold.co/?utm_source=newsletter&utm_medium=email&utm_campaign=manifold-cooperpress&utm_content=postgres-weekly)Especially when you have many services on different platforms. Manifold helps you manage all your services with a single account. We have awesome partners like JawsDB, LogDNA and Mailgun. Start building your stack today. Manifold#sponsored[![\](https://copm.s3.amazonaws.com/10b9e61b.png)](https://www.manifold.co/?utm_source=newsletter&utm_medium=email&utm_campaign=manifold-cooperpress&utm_content=postgres-weekly) [Another Way to Optimize PostgreSQL](https://medium.com/jetruby/another-way-to-optimize-postgresql-use-case-f27fbf435b44?utm_source=postgresweekly&utm_medium=email)How to deal with data entry, slow selection, and possible collisions. JetRuby [Postgres Operations That You Can't 'Explain'](http://felixge.de/2017/05/05/postgresql-operations-that-you-cant-explain.html?utm_source=postgresweekly&utm_medium=email) Felix Geisendörfer [Using Sequelize ORM to Manage Relationships in A Postgres](https://medium.com/@zbbergma/using-sequelize-orm-to-manage-relationships-in-a-postgresql-database-4fb3f78dfa5b?utm_source=postgresweekly&utm_medium=email)Sequelize is one of many options in Node for working with Postgres. Here's a primer of what it is and how you can use it for your next Node app. Zachary Bergmann [Joining Two Tables by a Foreign Key Relationship](https://blog.olgaberezovsky.com/postgresql-joining-two-tables-which-are-not-related-by-a-foreign-key-relationship-a81c3504f78?utm_source=postgresweekly&utm_medium=email)Need to join two tables that aren’t explicitly related by some key? This post walks through the use case and how you can accomplish it. Olga Berezovsky [Writing a Firebase Clone with Postgres and Node.js (Part 1)](https://medium.com/@patrickackerman/writing-a-firebase-clone-with-postgresql-and-node-js-part-i-d0bf1d8f0ea8?utm_source=postgresweekly&utm_medium=email) Patrick Ackerman [PGObserver: A Postgres Monitoring Tool](http://zalando.github.io/PGObserver/?utm_source=postgresweekly&utm_medium=email)An open source tool to help you monitor a Postgres database and get insights on stored procedures, IO stats, index usage, and more. Zalando#tools [Linux cloud hosting starting at 1GB of RAM for $5/mo.](http://welcome.linode.com/postgres-weekly/?utm_source=cooperpress&utm_medium=sponsored&utm_campaign=postgres-weekly-sponsored)Get a Linode server up and running in seconds. Use promo code POSTGRES20 for a $20 credit on a new account. linode#sponsored [ora2pg: Migrate an Oracle Database to a Postgres Schema](https://github.com/darold/ora2pg?utm_source=postgresweekly&utm_medium=email) Darold#code    

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