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 204 — April 26, 2017
A Look at PostgreSQL 9.6's Parallel Queries
A major feature in 9.6 was the parallel execution of sequential scans, joins and aggregates. Here’s a very high level look at what that means.
Tomasz Stachewicz   #tutorial 
Using R Analytic Functions in PostGIS
Combining the power of Postgres, PostGIS and R for measuring vegetation in an area over time.
Joe Conway   #tutorial 
Analyzing PostgreSQL Email Archives with PostgreSQL
Tom Lane is one of the largest contributors to Postgres, this post analyzes some of the Postgres mailing list archives for emails with some fun findings. (An updated post originally from 2013.)
Citus Data
Because Your Data Is Your Business
PGX's open source experts provide the database and application skills necessary to solve database problems, accelerate existing applications, refactor infrastructure, and develop new applications.
PostgreSQL Experts, Inc.​    #sponsored 
AWS Opens Access to Preview of PG-Flavored Amazon Aurora
All AWS customers can now use the Postgres-compatible variant of its Amazon Aurora database service.
Amazon Web Services, Inc.​   #news 
When Autovacuum Does Not Vacuum
Autovacuum generally works pretty well and keeps your database healthy and performing quickly, but there are some things that can introduce complications as highlighted here such as long running queries.
Tomas Vondra   #tutorial 
A 'Using Sequences in Postgres' FAQ
Most applications these days use sequences (via serial) without even realizing it. Here’s a great primer on how they work and some of the details about them.
Neil Conway   #tutorial 
Setting Up A Custom Replication Conflict Handler in Postgres
Kaarel Moppel   #tutorial 
'int4' vs 'int8' vs UUID vs 'numeric' Performance on Bigger Joins
Kaarel Moppel   #opinion 
Pgweb: A Cross-Platform Client for Postgres
Built using Go and works on macOS, Linux and Windows.
Dan Sosedoff   #tools 
Kallax: A New Typesafe Postgres ORM for Go
Kallax uses code generation for both type safety and performance. This post also digs into why they felt a new ORM was needed in Go.
Miguel Molina   #code 
Linux cloud hosting starting at 1GB of RAM for $5/mo.
Get a Linode server up and running in seconds. Use promo code POSTGRES20 for a $20 credit on a new account.
linode    #sponsored 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.