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.


XLogCtl->LogwrtRqst.Write

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
  EnterpriseDB   http://www.enterprisedb.com

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

              http://www.postgresql.org/docs/faq

Reply via email to