#236: Reducing Disk Bloat with pg_repack

.

Read this on the Web

Postgres Weekly Issue 236 — December 13, 2017

Reducing Disk Bloat with pg_repack An extension for removing ‘bloat’ from tables & indexes without taking exclusive locks. Knut Ingvald Dietzel PGCon 2018 Call for Papers Now Open The conference will take place on 29 May - 1 June at the University of Ottawa. Deadline for submissions is 19 Jan 2018. PGCon   #news  There's One Big Reason That Postgres Can't Kill Oracle PG is popular but can’t unseat Oracle which continues to thrive with its contracts and ‘stickiness’. Matt Asay   #opinion  Get the Health of Your PostgreSQL Database Checked by 2ndQuadrant Experts Prevention is better than a cure. The same is true for your PostgreSQL database. Our experts examine many aspects of your databases and determine the overall health in areas like performance, security, data loads, availability and compliance. 2ndQuadrant PostgreSQL Services    #sponsored  Performance Best Practices for Using Azure Database for Postgres At Build 2017, Microsoft announced the preview of Azure Database services for PostgreSQL, a simple, fully managed PostgreSQL database service. Here are some tips for working with it. Amit Banerjee   #news  'IS DISTINCT FROM': For Treating Two NULLs As Equivalent In SQL null = null isn’t true. Postgres’s support for IS NOT DISTINCT FROM helps when you need to make null-aware comparisons. Markus Winand Adding Unsigned 256 Bit Integers in Postgres It’s possible with the pg-bignum library. Stack Exchange Using Postgres Arrays from Go(lang) RapidLoop How We Built a PostgreSQL Cluster in a Box The ‘box’ is quite literal, too. The tech leant on Patroni, an open source tool for building highly available clusters. Cybertec If Postgres Used Threads Instead of Processes..? A technical post covering how a developer created a simple prototype for some basic benchmarks, but the reaction was lukewarm. Konstantin Knizhnik Queen, Princesses, and Workers A proposal for clarifying the terminology around ‘primary’ and ‘standby’ servers in complex Postgres setups. Dimitri Fontaine   #opinion  Chart Your Course to Become a Postgres Expert Demand for skilled Postgres resources is exceeding supply. Invest in your career. Get EDB Postgres Certified. EnterpriseDB    #sponsored  PostgreSQL PHP Generator Lite Released A commercial Windows app for creating PHP & PG-backed sites without any coding needed. SQL Maestro 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