The checkpointer is entirely incapable of either detecting the problem
(it doesn't have enough infrastructure to examine pg_database in a
reasonable way) or preventing backends from doing anything if it did
know there was a problem.
Well, I guess I meant 'some regularly running process'...
I think people'd rather their db just stopped accepting new transactions
rather than just losing data...
Not being able to issue new transactions *is* data loss --- how are you
going to get the system out of that state?
Not allowing any transactions except a vacuum...
autovacuum is the correct long-term solution to this, not some kind of
automatic hara-kiri.
Yeah, seems like it should really happen soon...
Chris
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match