Marco Colombo <[EMAIL PROTECTED]> writes: > Good to know, thanks. I think I'll experiment a bit with > archive_command. My point was that since I know (or better assume) that > old segments are going to stay in my pg_xlog for *days* before getting > recycled,
On what do you base that assumption? Once the system thinks they're not needed anymore, they'll be recycled immediately. regards, tom lane ---------------------------(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