Re: pgbench questions

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 pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026