On Thu, 5 Feb 2004, Tom Lane wrote: > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > > 'k, only comment is on this one ... would it not be a bit more efficient > > to add a flag to the "SMgrRelation *" structure that acts as a timer? > > Hm, we could try that, although I'm not sure it would help much. You'd > have to set the timeout to be longer than a checkpoint interval to make > any difference.
Why? Setting it to the checkpoint interval itself should be sufficient, no? All you want to do is avoid closing any files that were used during that last checkpoint interval, since there is a good chance you'd have to once more reopen them in the checkpoint interval ... ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
