#259 — June 6, 2018

Read on the Web

Postgres Weekly

Fun with SQL: Window Functions in Postgres — 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 — 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)

Multimodel Flexibility with 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? — 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 — 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 — 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 — Want to play with Postgres 11 on AWS RDS already? It’s possible.

Amazon Web Services

More on Postgres Trigger Performance — A performance test of some complex Postgres trigger usage scenarios.

Kaarel Moppel

A Brief History of PostgreSQL — 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 — 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

2ndQuadrant PostgreSQL Products sponsor

Odyssey: A Scalable Postgres Connection Pooler — Advanced multi-threaded PostgreSQL connection pooler and request router.

Yandex

Events

Swiss PGDay 2018 June 29 (Rapperswil, Switzerland) Take the opportunity to meet with other people interested in PostgreSQL in Switzerland.

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 September 5-7 (San Francisco, CA) Two days packed with tutorials and presentations about PostgreSQL. Talk submissions will be accepted up until June 12.