OH: "PostgreSQL is the Linux of databases" It's probably equally unstoppable and will completely dominate the database ecosystem in the next 10-20 years. What's your opinion on this?
-
-
I'd add autovacuum. But I understand that getting rid of it requires a major architectural change and I don't know if it's realistically possible.
-
There's plenty more. Not sure about autovacuum in particular however: While our scheduling around it needs improvement, there's also some substantial gains from not needing full undo. FWIW, it's definitely fixable. There are actually quite a few patches around undo/zheap out.
- 4 more replies
New conversation -
-
-
Often that's because we'd determined, quite possibly justified at the time, that we can't do a good job at X fully/… due to being a small open source project. Sometimes we were too defensive to admit that. Over time may of those shortcuts became enshrined as good ideas.
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
Pretty much the thing that annoys me the most right now is that logical replication is literally broken if you consider failover. Five years and failover still destroys logical replicas.
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
And even if we do fix it it'll take at least a year to get in, during which time you're pretty much screwed, or you can tick off some debug things that will screw up all your other queries...
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.
