Thread: Checkpoints
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
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 >
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 >