Postgres Weekly Issue 73
September 17, 2014
A Look at Postgres' Window Functions
Window functions allow you to order and iterate over data in a powerful way for reporting. Take a look at how they often even make your queries simpler.
Thoughtbot
A Large Database Does Not Mean Large shared_buffers
There’s a lot of talks and articles out there around customizing your Postgres config, especially for getting started. Here’s another one to add to the file specifically focused on large databases and what shared_buffers can mean to you.
Keith Fiske
pg_sysdatetime: A Cross-Platform PostgreSQL Extension
pg_sysdatetime may not be an overly powerful extension, but it provides a great example of an extension that works across all platforms, the one of biggest note that’s often left out being Windows. If you’re building an extension yourself take note.
2ndQuadrant
Comprehensive Administration with Bruce Momjian
Join a live on-line training session with Postgres leader Bruce Momjian and get certified in PostgreSQL Administration. This is your last chance this year to enhance your skills and be trained by the best with a combined basic + advanced Postgres administration course.
EnterpriseDB  Sponsored
Postgresql HStore, JSON Data-Type and Arrays with Peewee ORM
Peewee is a handy ORM that supports a variety of databases, while it treats many of them equally it also is able to take advantage of all of the powerful functionality in Postgres with certain extensions.
Charles Leifer
Beyond Random() — Normal Distributions in SQL
Generating fake data, but want it to appear realistic within your database? Look no further than this awesome example of generating normally distributed data.
Periscope
PostgresSQL JSON Add Delete Functions
JSON in Postgres continue to keeps improving, first we had basic validation. Then operators came along to help further, and now they’re continuing to be enriched with new functions for adding/deleting to JSON data.
Sumit Chawla
Accelerating Local Search with PostgreSQL (KNN-Search)
If you want a cheap way of finding how similar two things are Postgres has an answer for you and it doesn’t require a ton of extra application logic. Here’s a deck from a few years ago which still holds true today.
Jonathan S Katz