Viewing profile — rhaas

The infrastructure is intentionally pluggable to facilitate different viewpoints on questions like this. I hope we see various add-on modules pop up that fetch advice strings from …

I agree that for many use cases, standbys and in particular time-delayed standbys are a better option than backups. That said, having off-line backups in tamper-proof storage is a …

I have been a PostgreSQL hacker since 2008 and a PostgreSQL user for many years before that. The first mention of my name in the PostgreSQL commit log is in 2003, and the first ver…

The only name I can find on the "Fundación PostgreSQL" web site is yours. The PostgreSQL core team membership is listed on postgresql.org and includes 7 members from 4 different co…

I wrote a previous post on why MVCC is interesting, and how it relates to the topic at hand. It's the first link in the article. I don't think that it's accurate to say to say that…

Uh, indexes in postgres point to the tuple, not the page. Except for BRIN.

The first release of PostgreSQL that had synchronous replication was released in September 2011. https://www.postgresql.org/docs/9.1/static/release-9-1.html

The work that has been done on transition tables is intended to enable future work on automatically updated materialized views; the idea is that the system will automatically deriv…

I agree with you that stored procedures are superior to client-side logic, because it means that you can have multiple routes of access to the database and all of them enforce the …

Replication across major versions, for example to upgrade without downtime. Partial replication, to distribute shared data across a series of clusters, or for analytics and reporti…

I hope that it will have that effect. We need a few other features first: partitionwise join, partitionwise aggregate, asynchronous query, and ideally hash partitioning.

Yep, see http://rhaas.blogspot.com/2010/11/mysql-vs-postgresql-part-1...