#227: A Postgres Concurrency Deep Dive

.

Read this on the Web

Postgres Weekly Issue 227 — October 4, 2017

A Deep Dive into Postgres Concurrency An easy to follow 50 minute talk from PostgresOpen Silicon Valley 2017 on different forms of concurrency and how Postgres works with them. Tejas Manohar   #video  Fermi Estimates on Postgres Performance A simplified guide for what you should expect in terms of the read performance and ingest performance for queries in Postgres. Samay Sharma 2ndQuadrant PostgreSQL Conference - Schedule Out Now 2Q PGConf is dedicated to exchanging & increasing knowledge about PostgreSQL. Join us for this unique opportunity taking place in NYC & Chicago to learn more about recent achievements and exciting future developments in PostgreSQL from world-class experts. 2ndQuadrant PostgreSQL Events    #sponsored  Locking Down Permissions in Postgres and on Redshift Users are automatically granted permissions due to their membership in a built-in role called PUBLIC. Buck Ryan Swap Two Column Values in SQL Want to swap the order of a few columns without having to drop/remove or re-write the whole table? Part 2 here. Josh Branchaud Getting Started with pgRouting to Create Location Paths pgRouting is useful if you’re already using PostGIS. It can be handy for helping find various paths and routes between locations, here’s a primer on getting started with it. Compose A Look at PERCENT_RANK vs CUME_DIST cume_dist computes the %age of rows that are ‘less than or equal,’ while percent_rank computes those that are ‘less than’ the current row, except it also assumes the current row isn’t in the partition. Bruce Momjian Understanding Caching in Postgres - An In-Depth Guide A golden oldie from last year that might be worth revisiting. Madusudanan B N pglogical and Postgres 10 Partitions A look at Postgres 10’s logical replication and partitioning support, how it plays with pglogical, and how it’s still evolving. 2ndQuadrant Using the Invisible 'xmin' Column in Queries Select for update is usually what you want when grabbing a value that you’re going to update right after, but here we see where using xmin could be a valid approach. momjian.​us Linux cloud hosting starting at 1GB of RAM for $5/mo Get a Linode server up and running in seconds. Get a $20 credit on a new account. Linode Cloud Hosting    #sponsored  PGAudit: An Auditing Extension for Postgres Provides the tools needed to produce audit logs required to pass government, financial, or ISO certification audits. PostgreSQL Global Development Group   #tools  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