Evgeny Gridasov wrote:
> Hello.
>
> So, what happens if I set checkpoint_segments and checkpoint_timeout very
> high,
> and, shared_buffers to a very low value?
> Will PostgreSQL force a checkpoint when it has not enough memory in
> shared_buffers for some new "un-checkpointed" data ?
It won't
Hello.
So, what happens if I set checkpoint_segments and checkpoint_timeout very high,
and, shared_buffers to a very low value?
Will PostgreSQL force a checkpoint when it has not enough memory in
shared_buffers for some new "un-checkpointed" data ?
On Fri, 12 Jan 2007 10:49:04 -0300
Alvaro Herre
Evgeny Gridasov wrote:
> Hello.
>
> Lets's imagine a sequence in time:
> (1) Some transactions commit data (simple table inserts/updates).
> (2) I get data from a table using select.
> (3) A CHECKPOINT occurs, data from pg_xlog is copied to actual table data
> files.
>
> Questions:
>
> Where do
