---
title: "This Week's PostgreSQL News (#73)"
publication: "Postgres Weekly"
issue: 73
published_at: "2014-09-17"
canonical_url: "https://postgresweekly.com/issues/73"
---

Postgres Weekly Issue 73 - September 17, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/73)**Postgres Weekly****Issue 73**
September 17, 2014[A Look at Postgres' Window Functions](http://robots.thoughtbot.com/postgres-window-functions?utm_source=postgresweekly&utm_medium=email)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](http://www.keithf4.com/a-large-database-does-not-mean-large-shared_buffers/?utm_source=postgresweekly&utm_medium=email)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](http://blog.2ndquadrant.com/pg_sysdatetime_windows_xplatform_postgresql_extension/?utm_source=postgresweekly&utm_medium=email)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](http://www.enterprisedb.com/store/products/dba-training/01t50000002jwhqAAA?utm_source=CP=NL=3ComboBM?utm_source=postgresweekly&utm_medium=email)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._EnterpriseDBSponsored_[![\](http://s3.amazonaws.com/nlga/uploads/item/image/26807/i.png)](http://www.enterprisedb.com/store/products/dba-training/01t50000002jwhqAAA?utm_source=CP=NL=3ComboBM?utm_source=postgresweekly&utm_medium=email)[Postgresql HStore, JSON Data-Type and Arrays with Peewee ORM](http://charlesleifer.com/blog/postgresql-hstore-json-data-type-and-arrays-with-peewee-orm/?utm_source=postgresweekly&utm_medium=email)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](https://periscope.io/blog/beyond-random-normal-distributions-in-sql.html?utm_source=postgresweekly&utm_medium=email)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](http://chawlasumit.wordpress.com/2014/09/14/postgressql-json-add-delete-operation-functions/?utm_source=postgresweekly&utm_medium=email)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)](http://www.slideshare.net/jkatz05/knn-39127023?utm_source=postgresweekly&utm_medium=email)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_Curated by [Craig Kerstiens](http://craigkerstiens.com/) and published by [Cooper Press](https://cooperpress.com/).
Want to sponsor an issue? See our [media kit.](https://cooperpress.com/mediakit2014q2.pdf)

 © 2017 Cooper Press Ltd. [Email policy](https://cooperpress.com/spam.html) [Privacy policy](https://cooperpress.com/privacy.html)
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK[Update your email address](*|UPDATE_PROFILE|*)
or [unsubscribe here](*|UNSUB|*)