---
title: "Fun with SQL: Window Functions in Postgres"
publication: "Postgres Weekly"
issue: 259
published_at: "2018-06-06"
canonical_url: "https://postgresweekly.com/issues/259"
---

The latest Postgres news, articles, tools, and projects.       

#259 — June 6, 2018 

[Read on the Web](https://postgresweekly.com/issues/259)   

Postgres Weekly  

[Fun with SQL: Window Functions in Postgres](https://www.citusdata.com/blog/2018/06/01/fun-with-sql-window-functions-in-postgresql/) — Window functions are key in various analytic and reporting use cases where you want to compare and contrast data. 

Craig Kerstiens   

[Benchmarking Cassandra vs. TimescaleDB for Time-Series Data](https://blog.timescale.com/time-series-data-cassandra-vs-timescaledb-postgresql-7c2cc50a89ce) — How a five node TimescaleDB (a Postgres extension) cluster outperforms 30 Cassandra nodes, with higher inserts and up to 5800x faster queries. 

Lee Hampton (TimescaleDB)   [![\](https://copm.s3.amazonaws.com/ff617dd9.png)](https://www.enterprisedb.com/customers/inmobi-delivers-billions-mobile-ad-impressions-month-edb-postgres) 

[Multimodel Flexibility with EDB Postgres](https://www.enterprisedb.com/customers/inmobi-delivers-billions-mobile-ad-impressions-month-edb-postgres) — Learn how the unique capabilities of EDB Postgres helps inMobi serve more than 26 billion ad impressions per month worldwide. 

EnterpriseDB sponsor   

[Who Contributed to Postgres Development in 2017?](http://rhaas.blogspot.com/2018/06/who-contributed-to-postgresql.html) — A belated look at those who contributed ‘at least 1 new line of code’ (that’s 170 people) to the Postgres project last year. 

Robert Haas   

[PGInstaller: A GUI Based, User-Friendly Installer for Postgres](https://blog.2ndquadrant.com/postgresql-installer/) — A Windows, Mac, & Linux-based option for installing Postgres 9.5, 9.6, 10 or 11 (beta). 

2ndQuadrant   

[Using Bits for Efficient Storage in Postgres](https://blog.opendigerati.com/using-bits-for-efficient-storage-in-postgres-4f670f125269) — An example of how you can efficiently store millions of data points in Postgres using binary. 

Chris Vaughn   

[PostgreSQL 11 Beta 1 Now Available in Amazon RDS Database Preview Environment](https://aws.amazon.com/about-aws/whats-new/2018/05/postgresql-11-beta-1-now-available-in-amazon-rds-database-previe/) — Want to play with Postgres 11 on AWS RDS already? It’s possible. 

Amazon Web Services   

[More on Postgres Trigger Performance](https://www.cybertec-postgresql.com/en/more-on-postgres-trigger-performance/) — A performance test of some complex Postgres trigger usage scenarios. 

Kaarel Moppel   

[A Brief History of PostgreSQL](https://medium.com/launch-school/a-brief-history-of-postgresql-36d8d392c611) — Ever wonder where PostgreSQL came from? This looks at the origin of Postgres and a few other databases you may be familiar with. 

Wendy Kuhn   

▶[Postgres 10, Performance, and You](https://www.youtube.com/watch?v=8gXdLAM6B1w) — PostgreSQL 11 is coming in a few months, but if you haven’t caught up on PostgreSQL 10 here’s the rundown of features and improvements contained–and some good excuses for why you should upgrade. 

Gabe Enslein   

[Postgres-BDR3 Whitepaper Now Available - Features, Use Cases & Deployment](https://www.2ndquadrant.com/en/resources/postgres-bdr-2ndquadrant/postgres-bdr-download-white-paper-replication-postgresql/?utm_source=cpweekly&utm_medium=text&utm_campaign=cpbdrwp) 

2ndQuadrant PostgreSQL Products sponsor   

[Odyssey: A Scalable Postgres Connection Pooler](https://github.com/yandex/odyssey) — Advanced multi-threaded PostgreSQL connection pooler and request router. 

Yandex  

Events  

[Swiss PGDay 2018](https://www.pgday.ch/2018/) — **June 29 (Rapperswil, Switzerland)** Take the opportunity to meet with other people interested in PostgreSQL in Switzerland.    

[PGDay.Amsterdam](http://pgday.amsterdam/) — **July 12 (Amsterdam, Netherlands)** Meet & learn from other PostgreSQL users, developers and anyone who’s interested in the most advanced open source database.    

[PostgresOpen 2018](https://2018.postgresopen.org/) — **September 5-7 (San Francisco, CA)** Two days packed with tutorials and presentations about PostgreSQL. Talk submissions will be accepted up until June 12.          

Curated by [Cooperpress](https://cooperpress.com/) and [Craig Kerstiens](https://twitter.com/craigkerstiens) 

[Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom