I sent this yesterday, but it seems not to have made it to the list...
I have a couple of comments orthogonal to the present discussion. 1) It would be fairly easy to write log records over a network to a dedicated process on another system. If the other system has an uninterruptible power supply, this is about as safe as writing to disk. This would get rid of the need for any fsync on the log at all. There would be extra code needed on restart to get the end of the log from the other system, but it doesn't seem like much. I think this would be an attractive option to a lot of people. Most people have at least two systems, and the requirements of the logging system would be minimal. 2) It is also possible, with kernel modifications, to have special logging partitions where log records are written where the head is. Tzi-cker Chueh and Lan Huang at Stony Brook (http://www.cs.sunysb.edu/~lanhuang/research.htm) have written this, although I don't think they have released any code. (A similar idea called WADS is mentioned in Gray & Reuter's book.) If the people at Red Hat are interested in having some added value for using PostgreSQL on Red Hat Linux, this would be one idea. It could also be used to speed up ext3 and other journaling file systems. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
