Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
Postgres Weekly
Issue 200 — March 29, 2017

It's issue 200! To celebrate, we've dug through our 4 years of archives and found some popular posts that are still interesting today. Enjoy them in the second half of this issue - here's to 200 more :-) Thanks for your support.

Why Does A JSON Element Return Text When It's Not Text?
JSON and JSONB are really powerful when working with Postgres, but it doesn’t mean they’re not without their quirks. Here we look at why text is typically the return value.
Database Administrators Stack Exchange
How We Implement Disaster Recovery and High Availability with Postgres on Citus Cloud
Disaster recovery and high availability are key in running and managing your database, whether on your own or as-a-service disaster can strike and you need to be prepared. Here’s a primer on what each is and how Citus Cloud implements both.
Citus Data
Postgres-XL: MPP and Horizontally Scalable PostgreSQL
Postgres-XL is a Massively Parallel Database built on top of, and very closely compatible with PostgreSQL 9.5. It's flexible enough to handle simultaneous OLAP & OLTP workloads and is designed to be Horizontally Scalable.
2ndQuadrant PostgreSQL Products    #sponsored 
Tgres: A Go and PostgreSQL-Powered Time Series Data Integrator
A Go program which receives time series data via Graphite, Statsd, or even a Web pixel, stores it in PostgreSQL, and provides Graphite-like access to the data.
Gregory Trubetskoy   #tools 
pgDevOps: A Web Console for Managing Postgres Servers
If you need a turnkey admin console for managing Postgres, PgDevOps may help. It’s a multi-user and multi-server Postgres web console for devops that features integration with pgAdmin4.
Dvir Volk   #tools 
PipelineDB 0.9.7: Delta Streams & Towards a Postgres Extension
PipelineDB allows you to turn Postgres into a streaming database, but perhaps most exciting is it’s moving towards becoming an extension in future.
Derek Nelson
Postgres vs MySQL - Which Should You Pick As Your Next Analytical Database?
While the debate may be open for which OLTP database you want to use, Postgres has a pretty clear advantage over MySQL when it comes to analytics. It’s no surprise there’s a number of forks to make it even better as an analytical database with these features.
Ganesh Swami
Faster Operations with the JSONB Data Type in PostgreSQL
Guest writer Lucero Del Alba takes a look at how to get better performance out of JSONB data types in Postgres.
Compose    #sponsored 
Gold from the archives
Using PostgreSQL Arrays The Right Way (2014)
Heap is clearly a power user of Postgres had some fantastic Postgres blog posts in 2014. You can also still enjoy Speeding Up Postgres with Partial Indexes and Creating Postgres Arrays Without A Quadratic Blowup.
Heap Blog
Writing Postgres Extensions - The Basics (2015)
Postgres extensions can be extremely powerful from geospatial to sharding and here’s a great guide to getting started writing your own.
Big Elephants
Finding the Nearest Big City (2013)
Postgres has 7 different index types and continues to grow. Here’s a real world example of using KNN (K-Nearest Neighbor) indexes for finding the nearest big city or nearest big ‘X’ given some set of conditions.
Dimitri Fontaine
Window Functions in Action (2013)
Window functions are in the intermediate to power user territory, but key to reporting with Postgres. This post, is still a classic of not only using window functions but also combining them with common table expressions, arrays, and composite types.
Joshua Tolley
Trees and Paths using WITH RECURSIVE in PostgreSQL (2014)
CTEs can be incredibly powerful and expressive, not just for readability within Postgres, allowing you to deliver recursive queries without plpgsql or another pl language.
Neil McGuigan
UUID vs BIGSERIAL for Primary Keys (2015)
The Build
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.