Re: Oracle vs. PostgreSQL - a comment on Mysql - Mailing list pgsql-general

On the topic of what other databases do better: I much prefer Postgres to Mysql because it has better string functions and better as well as very courteous error messages. But MySQL has one feature that sometimes makes me want to return it: it stores the most important metadata about tables in a Mysql table that can be queried as if it were just another table.  That is a really feature. I makes it very easy to look for a table that you edited most recently, including a lot of other things.

Why doesn’t Postgres have that feature? Or is there a different and equally easy way of getting at these things that I am just missing?

[...]

 

Regardless of what Oracle does, I agree this would be a huge step in the right direction for pg-DBAs.

I have absolutely no clue about how much work is required etc., but I think it's kind of strange that no companies have invested in making this happen.

 

I manage database clusters where the number of databases is a reason not to do logical replication based upgrades, where pg_upgrade is far preferred instead.

 

If this were to be the case, I would be very concerned that a bunch of things would have to change:

1.  Shared catalogs would have txid problems unless you stay with global txids and then how do local wal streams work there?

2.  Possibility that suddenly streaming replication has the possibility of different databases having different amounts of lag

3.  Problems with io management on WAL on high throughput systems (I have systems where a db cluster generates 10-20TB of WAL per day)

 

So I am not at all sure this would be a step in the right direction or worth the work.