"Barry" <[EMAIL PROTECTED]> writes: > After running for a couple of days, my postgres server crashes.
Sounds to me like you are starting the postmaster under some resource limit that it eventually exceeds. Check ulimit settings. regards, tom lane ---------------------------(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