> So this might be a dumb question, but the above statements apply to the > cluster (e.g. postmaster) as a whole, not per postgres > process/transaction correct? So each transaction is blocked waiting for > the main postmaster to retrieve the data in the order it was requested > (i.e. not multiple scanners/aio)?
Each connection runs its own separate back-end process, so these statements apply per PG connection (=process). ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster