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

Reply via email to