rachbelaid (u/rachbelaid)

rachbelaid commented on New Features Coming in PostgreSQL 10 rhaas.blogspot.com/2017/0... · Posted by u/ioltas

mb4nck · 8 years ago

About redirection of write queries to the master, from 10 on, you will be able to specify all members of the cluster in the connection string and demand to connect to the master (like "postgresql://host1:5432,host2:5432/somedb?target_session_attrs=read-write"); libpq will do this automatically for you then, see the parameters "host" (now plural) and "target_session_attr" in section 33.1.2. here: https://www.postgresql.org/docs/devel/static/libpq-connect.h...

About raft-based leader-election, I believe the current recommendation is to look at patroni ( https://github.com/zalando/patroni), which has been built for docker and is now being integrated with Kubernetes; however, I don't think there is an inherent limitation that it couldn't be run on bare-metal.

rachbelaid · 8 years ago

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.

rachbelaid commented on New Features Coming in PostgreSQL 10 rhaas.blogspot.com/2017/0... · Posted by u/ioltas

fiatjaf · 8 years ago

Ok, I'm not a database manager for enormous projects, so these changes may be great, but I don't understand them and don't care about them. Postgres is already the most awesome thing in Earth to me.

Still, if my opinion counts I think SELF-UPDATING MATERIALIZED VIEWS should be the next priority.

rachbelaid · 8 years ago

Some work started in this direction. I didn't follow closely the whole thread but I don't think that got commited in PG10.

https://www.postgresql.org/message-id/flat/20170119213859.GA...

More info in the EDB roadmap: https://wiki.postgresql.org/wiki/EnterpriseDB_database_serve...

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.

rachbelaid commented on Implement table partitioning git.postgresql.org/gitweb... · Posted by u/rachbelaid

rachbelaid · 9 years ago

The conversation on the patches are really interesting: https://www.postgresql.org/message-id/flat/55D3093C.5010800@...https://www.postgresql.org/message-id/flat/ad16e2f5-fc7c-cc2...