Thread: Checkpoints

Checkpoints

From
Nailah Ogeer
Date:
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



Re: [GENERAL] Checkpoints

From
Dennis Gearon
Date:
pool of what?

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
>


Re: [GENERAL] Checkpoints

From
Dennis Gearon
Date:
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
>