---
title: "This Week's PostgreSQL News (#130)"
publication: "Postgres Weekly"
issue: 130
published_at: "2015-11-04"
canonical_url: "https://postgresweekly.com/issues/130"
---

Postgres Weekly 130   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 130 — November 4, 2015     

[Don’t Assume PostgreSQL is Slow](http://thebuild.com/blog/2015/10/30/dont-assume-postgresql-is-slow/?utm_source=postgresweekly&utm_medium=email)It’s generally assumed Postgres is slow when it comes to count(*), and while it often can be, it may not be too bad for you depending on your data – as highlighted by this simple example. The Build [Safe Operations For High Volume PostgreSQL](https://www.braintreepayments.com/blog/safe-operations-for-high-volume-postgresql/?utm_source=postgresweekly&utm_medium=email)Postgres is generally quite flexible for 1. keeping your data safe and 2. letting you make changes to the schema. But it’s not always perfect, Braintree, a high throughput service and Postgres shop, highlights some of the gotchas here. braintreepayments.​com [SQL Tabs: A Rich (Open Source) SQL Console for Postgres](http://www.sqltabs.com/?utm_source=postgresweekly&utm_medium=email)An open source cross platform desktop client for Postgresql with a database explorer, chart output from query results, themes, a Vim-style editing mode, and more. Aliaksandr Aliashkevich#tools [Scale Out Postgres for Real-Time Big Data Using CitusDB](http://info.citusdata.com/BigDataPW4.html)CitusDB delivers [real-time insights](http://info.citusdata.com/BigDataPW3.html) into your Big Data while reducing the cost and complexity of your database infrastructure and leverages your existing knowledge and applications. Supports structured or unstructured data and [horizontally scales.](http://info.citusdata.com/BigDataPW3.html) Citus Data#sponsored[![\](https://copm.s3.amazonaws.com/8aa06404.png)](http://info.citusdata.com/BigDataPW4.html) [Writing Postgres Extensions - Debugging](http://big-elephants.com/2015-10/writing-postgres-extensions-part-iii/?utm_source=postgresweekly&utm_medium=email)For those of you that have been following along and attempted to dig in and create your own Postgres extension, the next part in the series is invaluable for anyone attempting to do something useful. Debugging will admittedly be a bit more work than for your standard Ruby or Python app, but you can at least get started with this write-up. Big Elephants [PGJSON: Use Postgres As A Zero-Config NoSQL Database from Node](https://github.com/fiatjaf/pgjson?utm_source=postgresweekly&utm_medium=email) Giovanni#code [Planning Parallel and Distributed Queries [PDF\]](https://docs.google.com/viewer?a=v&pid=sites&srcid=ZGVmYXVsdGRvbWFpbnxyb2JlcnRtaGFhc3xneDo1ZmFhYzBhNjNhNzVhMDM0)Parallelism as well as distributed queries are two options for getting more performance when running queries across a large dataset. This talk deck runs you through the state of options today in Postgres, as well as a hint of what the future may hold. Robert Haas#code [pg-auth: An Auth System Built in Postgres using Schemas and Functions](https://github.com/robconery/pg-auth?utm_source=postgresweekly&utm_medium=email) Rob Conery#code [Node, Postgres, and Sequelize](http://mherman.org/blog/2015/10/22/node-postgres-sequelize/?utm_source=postgresweekly&utm_medium=email)One of the predominant Postgres libraries for Node just got a big update with migrations. Give a look at this updated post that walks you through Sequelize, an Object Relational Mapper. Michael Herman [The Design of the Spilo PostgreSQL Appliance](http://spilo.readthedocs.org/en/latest/DESIGN/?utm_source=postgresweekly&utm_medium=email)If you’re building an appliance and need a database somewhere within it this is a great read which covers many of the trade-offs both good and bad of Postgres as well as an in depth design. readthedocs.​org [Ready to Scale Your Job Hunt Into Offers?](https://hired.com/?utm_source=Postgres Weekly &utm_medium=newsletter&utm_campaign=q4_15-petercooperpress&utm_term=&utm_content=)Get interviews with top companies without submitting another application. Let companies find you through Hired - and offer salary and benefits upfront. Hired.​com#job    

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