Simon Riggs wrote:
On Sun, 2007-06-17 at 08:51 +0100, Heikki Linnakangas wrote:
Do we need to know it so exactly that we look
at WALInsertLock? Maybe use info_lck to request the latest page, since
that is less heavily contended and we need never wait across I/O.
Is there such a value available, that's protected by just info_lck? I can't see one.


That's the Write location. checkpoint_segments is calculated against the Insert location. In a normal OLTP scenario they would be close to each other, but if you're doing a huge data load in a transaction; restoring from backup for example, they could be really far apart.

  Heikki Linnakangas

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?


Reply via email to