Checkpoints - Mailing list pgsql-hackers

From Nailah Ogeer
Subject Checkpoints
Date
Msg-id Pine.SOL.4.33.0307221355530.27137-100000@innovate
Whole thread Raw
Responses Re: [GENERAL] Checkpoints  (Dennis Gearon <gearond@cvc.net>)
Re: [GENERAL] Checkpoints  (Dennis Gearon <gearond@cvc.net>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: php with postgres
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL 7.3.3 and Intel C compiler