Re: Checkpoints - Mailing list pgsql-general

From Dennis Gearon
Subject Re: Checkpoints
Date
Msg-id 3F1D88B1.7050708@cvc.net
Whole thread Raw
In response to Checkpoints  (Nailah Ogeer <ogeer@cs.queensu.ca>)
List pgsql-general
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@postgresql.org so that your
>       message can get through to the mailing list cleanly
>


pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: Checkpoints
Next
From: Dennis Gearon
Date:
Subject: Re: New Poll @ Codewalkers