pgsql-server: Dept.

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql-server: Dept.
Date: 2004-08-15 23:44:48
Message-ID: 20040815234448.17DCC5E46BF@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Dept. of further reflection: I looked around to see if any other callers
of XLogInsert had the same sort of checkpoint interlock problem as
RecordTransactionCommit, and indeed I found some. Btree index build
and ALTER TABLE SET TABLESPACE write data outside the friendly confines
of the buffer manager, and therefore they have to take their own
responsibility for checkpoint interlock. The easiest solution seems to
be to force smgrimmedsync at the end of the index build or table copy,
even when the operation is being WAL-logged. This is sufficient since
the new index or table will be of interest to no one if we don't get
as far as committing the current transaction.

Modified Files:
--------------
pgsql-server/src/backend/access/nbtree:
nbtsort.c (r1.85 -> r1.86)
(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/access/nbtree/nbtsort.c.diff?r1=1.85&r2=1.86)
pgsql-server/src/backend/commands:
tablecmds.c (r1.125 -> r1.126)
(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/commands/tablecmds.c.diff?r1=1.125&r2=1.126)
pgsql-server/src/backend/storage/smgr:
smgr.c (r1.77 -> r1.78)
(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/storage/smgr/smgr.c.diff?r1=1.77&r2=1.78)

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2004-08-16 01:26:31 pgsql-server: Clarify need for \r\n -> \n translation in version
Previous Message Tom Lane 2004-08-15 17:03:37 pgsql-server: Xmin calculations should consider only top transaction