"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes
>
> Why bother? Just write each page when you need to --- there's no law
> that says you must use P_NEW. The hash index type does something pretty
> similar, IIRC.
>
Is there any performance benefits if we have a mdextend_several_pages()
function in md.c? So the relation can be extended in a bulky way. In my
understanding, if we write
write(fd, buffer, BLCKSZ*10)
instead of
for (i=0; i<10; i++)
write(fd, buffer, BLCKSZ);
This will reduce some costs of file system logs for journal file systems. Of
course, the cost we have to pay is the longer time of holding relation
extension lock.
Regards,
Qingqing