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
