Re: Checkpoint question

u15074 <u15074@hs-harz.de> writes:
> Can you specify more exactly what you mean with update rate? I moslty perform
> inserts on the database (is that what you mean?).

Sure, inserts/updates/deletes.

> Also I do not understand, why checkpoint does not touch WAL, but RAM. I thought
> that a checkpoint reads the information from the WAL-Files and pushes these
> information to the data files.

Not in Postgres.  Updates are applied immediately to copies of the data
file pages in RAM; all that checkpoint has to do is force those buffers
out to disk.

            regards, tom lane