| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | "J(dot) R(dot) Nield" <jrnield(at)usol(dot)com> |
| Cc: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>, nconway(at)klamath(dot)dyndns(dot)org, PostgreSQL Hacker <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pgbench questions |
| Date: | 2002-07-13 21:59:15 |
| Message-ID: | 200207132159.g6DLxGM21734@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-07-14 00:02:58 | Re: Memo on dropping practices |
| Previous Message | J. R. Nield | 2002-07-13 21:53:50 | Re: pgbench questions |