Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
Postgres Weekly
Issue 111 — June 24, 2015
Discovering the Computer Science Behind Postgres Indexes
Don’t stop with just learning all the index types in Postgres (BTree, Gin, GiST, Sp-GiST, KNN, conditional, functional) make sure you go further and check out this final in the installment of what happens when you issue a query and how indexes actually work under the covers.
Pat Shaughnessy
Fashion Is Hard. PostgreSQL Is Easy
Zalando’s Head of Data Engineering, Valentine Gogichashvili, shares their experiences with PostgreSQL and how it fared scaling up to 100 million visitors per month.
Zalando   #video 
Oracle's Biggest Database Foe: Could It Be Postgres?
An EnterpriseDB survey showed 77% of users are dedicating all new deployments to PostgreSQL with 37% reporting they had migrated existing apps from Oracle or Microsoft SQL Server to Postgres.
TechRepublic   #opinion 
Unleash Real-Time Big Data on PostgreSQL with CitusDB
CitusDB delivers real-time end user insights into your big data while reducing the cost and complexity of your database infrastructure and leveraging your existing PostgreSQL knowledge and applications. Supports structured or unstructured data and elastically scales.
Citus Data    #sponsored 
Heroku PostgreSQL vs. Amazon RDS for PostgreSQL
If you want to use Postgres, but not run and maintain it yourself, Heroku or AWS are two compelling options. This is a thorough rundown of what you can expect from each.
Barry Jones   #opinion 
How to Debug Postgres using LLDB on a Mac
Very deep technical stuff, tread with care.
Pat Shaughnessy
Aggregate Queries Across PostgreSQL Schemas
Schemas are an often (but not always) awesome means for splitting up some data across different tables; think of them as good for lightweight sharding. But often when you split data up this way you want aggregate it up for some level of reporting, here’s a nice walk through of such.
Dave Clark
Connecting Neo4j to Any SQL Tool with the Power of Postgresql
A Python and Multicorn-based foreign data wrapper that brings together Neo4j and Postgres.
Benoît Simard   #tools 
Getting Postgres Version With Golang
A small but handy utility if you’re in ops on how to grab the Postgres version and then potentially other information about it from within Go.
Rob Sullivan   #code 
pg_idx_advisor: Index Advice for PostgreSQL
While it won’t be a magic bullet, this extension could certain add a ton of value and performance to your system by providing index recommendations for your databases.
Jony Vesterman Cohen   #tools #code 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.