Tom Lane wrote:
Heikki Linnakangas <[EMAIL PROTECTED]> writes:
A much simpler approach would be to try to acquire the vacuum lock, and
compact the page the usual way, and fall back to a cold update if we
can't get the lock immediately.
Seems like that could work.
I just realized that there's a big problem with that. The process doing
the update surely holds a pin on the buffer itself. Needs more thought..
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match