PostgreSQL
Understanding Window Functions
There was SQL before window functions and SQL after window functions: that’s how powerful this tool is. Being that of a deal breaker unfortunately means that it can …
category
PostgreSQL
132 posts
PostgreSQL
How far is the nearest pub?
In our recent article about The Most Popular Pub Names we did have a look at how to find the pubs nearby, but didn’t compute the distance in between that pub and …
PostgreSQL
The Most Popular Pub Names
In his article titled The Most Popular Pub Names Ross Lawley did show us how to perform some quite interesting geographic queries against MongoDB, using some nice Open …
PostgreSQL
Archiving data as fast as possible
In a recent article here we’ve been talking about how do do Batch Updates in a very efficient way, using the Writable CTE features available in PostgreSQL 9.1. I …
PostgreSQL
Simple Case for Pivoting in SQL
In a recent article Craig Kerstiens from Heroku did demo the really useful crosstab extension. That function allows you to pivot a table so that you can see the data from …
PostgreSQL
Nearest Big City
In this article, we want to find the town with the greatest number of inhabitants near a given location. A very localized example We first need to find and import some …
PostgreSQL
Bulk Replication
In the previous article here we talked about how to properly update more than one row at a time, under the title Batch Update. We did consider performances, including …
PostgreSQL
Batch Update
Performance consulting involves some tricks that you have to teach over and over again. One of them is that SQL tends to be so much better at dealing with plenty of rows …
PostgreSQL
HyperLogLog Unions
In the article from yesterday we talked about PostgreSQL HyperLogLog with some details. The real magic of that extension has been skimmed over though, and needs another …
PostgreSQL
PostgreSQL HyperLogLog
If you’ve been following along at home the newer statistics developments, you might have heard about this new State of The Art Cardinality Estimation Algorithm …
PostgreSQL
Extensions Templates
In a recent article titled Inline Extensions we detailed the problem of how to distribute an extension’s package to a remote server without having access to its …
PostgreSQL
Inline Extensions
We’ve been having the CREATE EXTENSION feature in PostgreSQL for a couple of releases now, so let’s talk about how to go from here. The first goal of the …