On Thu, 12 Jan 2006, Simon Riggs wrote:
>
> The only buffers this will miss are ones that were clean throughout the
> whole of the last checkpoint cycle, yet have been dirtied between the
> start of the checkpoint pass and when the pass reaches it.
I agree on the analysis but I am not sure current interval of doing a
checkpoint. So it depends. If the checkpoint on an io-intensive machine
the interval I guess would not be small. Also, in this environment, one
more round of lock cycle should be relatively cheap. But we currently
don't have any numbers on hand ...
Regards,
Qingqing
---------------------------(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
