Re: [PATCHES] [HACKERS] Load distributed checkpoint
"Inaam Rana" <[EMAIL PROTECTED]> wrote: > One of the issues we had during testing with original patch was db stop not > working properly. I think you coded something to do a stop checkpoint in > immediately but if a checkpoint is already in progress at that time, it > would take its own time to complete. > Does this patch resolve that issue? Yes, I fixed the problem. If a checkpoint by user SQL or shutdown is waiting during an automatic checkpoint, the running checkpoint will be done without any delays. At the worst case, you have to wait two checkpoints, (a running automatic checkpoint and your explicit request) but nothing more of them. > Also, is it based on pg82stable or HEAD? It's based on HEAD. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [PATCHES] [HACKERS] Load distributed checkpoint
On 2/26/07, ITAGAKI Takahiro <[EMAIL PROTECTED]> wrote: Josh Berkus wrote: > Can I have a copy of the patch to add to the Sun testing queue? This is the revised version of the patch. Delay factors in checkpoints can be specified by checkpoint_write_percent, checkpoint_nap_percent and checkpoint_sync_percent. They are relative to checkpoint_timeout. Also, checking of archive_timeout during checkpoints and some error handling routines were added. One of the issues we had during testing with original patch was db stop not working properly. I think you coded something to do a stop checkpoint in immediately but if a checkpoint is already in progress at that time, it would take its own time to complete. Does this patch resolve that issue? Also, is it based on pg82stable or HEAD? regards, inaam Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings -- Inaam Rana EnterpriseDB http://www.enterprisedb.com