With 2ndquadrant working on Postgres-XL (http://www.postgres-xl.org/), I think that you can be confident that you will see a lot of the features being proposed to core postgres. It will just take some times to build the building block necessary like: global index, distributed sequence, repartition ...
I quite confident that the postgresql from 5y in future will be quite different in term of storage / server topology support. I won't be surprise pg_bouncer capacity to finally make its way to core when we have a coordinator.
Postgres has steady progression (even if not fast enough for some people) but they are moving without compromising robustness of their product for the users.
Postgres has been amazing in shipping the foundation required to deliver complex feature.. Logical Replication is an example of it, all the piece commited in the last 6y allowed to make this patch achievable.
A quick update to say that few things got added since version 0.1 and you can find more details on the github release page. https://github.com/rach/pome/releases
(Author here) Thanks for the comment. I used Grafana and it's a great tool. One of the motivation behind this project is to be Battery included. A tool like Grafana require a timeseries DB (graphite or influx) then you need something to collect the metric like collectd and maybe an aggregator like statsd.
I want Pome to be simple to run as binary.
I did discuss the idea of allowing to disable the web and support pushing data to existing tools. I've been quite busy lately but the project is not dead.
Here the author.
Glad and scare that this project reached the 1st page of HN.
This project is at a very early stage but I had to release it at some stage. I wrote some explanation in the Readme [1] and in a blog post [2].
TL;DR: Pome aim to be very simple to deploy, opinionated and battery included tool to have a look at the health of your PG db. It's maybe not the case of anybody here but in my career, I have seen many PG db for which no health status were track (or because people think that RDS is magic). I assumed that if a very simple tool existed then it gives less reason to not track their health status.
At this stage, I don't think that Pome offers enough to be very useful but I hope that you will like the direction taken and where it's going.
Pome isn't aiming to be a tool for humongous Postgres instances which are already in the hands of a DBA who can have the time to setup more advanced monitoring tools. Pome won't be an alternative to a more configurable tool like collectd.
Yes, it supports RDS and I want to support it as it's the one that I used most often. It's really basic right now but I will add some new metrics this month.
To keep with the simplicity that I was aiming, I wanted a binary. I considered Rust, Haskell or Go (Swift was not opensource yet at the time) but went with Go because the libs that I will need (cron like scheduler, embedding assets, etc).
I had never written something in Go before but if I've known go then maybe I would have pick an other language as I started this project with a learning motivation.
Thanks for sharing this. I will look at which metrics that I can include from this project. I can also say that CPU can't happen to keep the project gathering data only through Postgres (except if you know a way)
The goal of Pome was to be very easy to setup for people who put nothing in place, which is why wrote it in Go. But if you have some time there is much better/complete tools like collectd.
Here the author. I understand your points, I wrote a bit about my personal motivation behind this project.
http://rachbelaid.com/introducing-pome/
I also wrote within the readme about why wrote the project (context+goals), https://github.com/rach/pome#why-building-pome
This project is not aimed to replace more advanced tool like collectd but to offer a basic all-in-one solution. I'm also not planning to support huge database for the scaling problem that you highlight.
Trying to offer something easy without RDD store constraint for people who right now doesn't monitor their db.
I hope this make the goals behind the project more clear.
There is also a patch to bring columnar storage into 9.6 (coming from the Axle project, EU founded). Definitively the gap becoming smaller but CitusDB is also having a lot of the glue built already with easy sharding (pg_shard) ..
It's an exciting time for PostgreSQL!
From what I've been reading on the on the development of 9.6 (https://commitfest.postgresql.org/), we may only see parallel seq scan and ordering coming to 9.6. They added the foundation to make more thing parallele but I don't think that we can hope to see parallel aggregation coming into 9.6
I had a similar experience. And event after living in a UK/US for 6y and my partner being a native english speaker, sometimes I struggle. One other frustration that I had, when you have to argue for your case. If you have to justify a solution against a native english speaker that can create some frustration as finding the right wording for the arguments can be sometimes a challenge.
Coming from Belgium, petke is also right about the influence of small language community. In example, in the flamish part (where belgian speak dutch), a lot of tv program and cinema is dub from english and even some cartoon. Where in the Walloons part (where belgian speak only french), we have access to the big tv network from France so we never watch anything in English.
But I remember reading that different languages use different sounds spectrum and hearing/understanding languages outside your spectrum is harder. Some languages have overlapping sounds spectrum which make learning different language easier. Now you have also the languages sharing the same roots and as you said somebody who know a germanic language then will have easier to guess/learn new vocabulary.
I quite confident that the postgresql from 5y in future will be quite different in term of storage / server topology support. I won't be surprise pg_bouncer capacity to finally make its way to core when we have a coordinator.
Postgres has steady progression (even if not fast enough for some people) but they are moving without compromising robustness of their product for the users.