hi,
what is the maximum amount of data to be written in checkpoint?

i always assumed this to be <shared_buffers>.

but some last tests show it to be much more. what am i missing?

best regards,

depesz

--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA. here's my CV!"
http://www.depesz.com/ - blog dla ciebie (i moje CV)

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

On Thu, 2008-01-24 at 11:21 +0100, hubert depesz lubaczewski wrote:

> what is the maximum amount of data to be written in checkpoint?
>
> i always assumed this to be <shared_buffers>.
>
> but some last tests show it to be much more. what am i missing?

Fsync will flush all outstanding writes, so you probably have some
writes that weren't yet flushed before the checkpoint started. If you
don't do any intermediate writing then this could be *all* of the data
you've written since the last checkpoint. If you want to reduce this,
set parameters to perform more regular writes from filesystem to disk.

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend