Re: Checkpoints

I mean, what is getting buffered? What performance effects is it supposed allow?

Nailah Ogeer wrote:

> Hello,
> I have written code to support multiple buffer pools in postgres 7.3.2.
> Now i am looking at changing the sizes of these buffer pools, but first i
> need to write all pages to disk.
> I also need to incorporate this code into the backend instead of it being
> a sql statement as it is now. I noticed that at a checkpoint, dirty pages
> are written to disk. I was just wondering if someone can tell me how
> postgres handles checkpoints and if it is advisable to do the sizing right
> after a checkpoint?
>
> Nailah
> MSc Student
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>