What is the relationship between checkpoint and wal

From: 高健 <luckyjackgao(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: What is the relationship between checkpoint and wal
Date: 2013-08-23 03:00:28
Message-ID: CAL454F3_vxV3pdV6kJ9d9k_TUS11Qp-WzMbGwn-U2yXGwQEH5w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello:

Sorry for disturbing.
I have one question : Will checkpoint cause wal written happen?

I found the following info at:
http://www.postgresql.org/docs/9.2/static/wal-configuration.html

...
Checkpoints are fairly expensive, first because they require writing out
all currently dirty buffers, and second because they result in extra
subsequent WAL traffic as discussed above.
...

What confused me is that: (checkpoint)result in extra subsequent WAL
traffic as discussed above...

I haven't found any more information can describe it in the "above" of that
page.

What I understand now is:

In Oracle, when checkpoint occur, it will flush data back to datafile.
At that time,
in oracle, even fulsh back to datafile will also cause log writer writing
to redo segment(rollback segment).

But for Postgreql,
I haven't found any information says that:
When checkpoint occurs, before flush to datafile, Postgresql must first
activate some logwriter to write to WAL, And then activate bgwriter or
backend process to write to data file.

Can anybody please give some url link which can say:
That Checkpoint will result in extra subsequent WAL traffic ?

I need some evidence to show to some guys in my team and to my boss.

Best Regards

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2013-08-23 03:30:09 Re: What is the relationship between checkpoint and wal
Previous Message 高健 2013-08-23 02:48:06 Re: How to know detailed information about HOT(Heap-Only Tuples)?