J. R. Nield wrote: > On Sat, 2002-07-13 at 02:25, Tatsuo Ishii wrote: > > > (2) At least in the current CVS version, the code to do a 'CHECKPOINT' > > > after creating a table has been #ifdef'ed out. Why is that? > > > > That is not after creation of a table, but while creating it, which is > > not necessary any more since Tom has fix the growth of WAL logs. > > > > Tatsou: > > Could you or Tom give me some background on what this change was about? > Is this something recent, or would it have been in CVS about a month > ago? > > I can't see any reason to force a checkpoint after CREATE TABLE, but it > would be interesting to know why it was done before.
7.1.0 had a problem with WAL file growth. This was fixed in 7.1.2 or 7.1.3 so checkpoint is not required anymore. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
