Hi!
Is there a NAT firewall or something like it involved anywhere between the two machines? If so, the connection may time out at some point in time, and neither server nor client would be notified that the connection is lost. An "ERROR: could not send data to client: Broken pipe" message indicates almost certainly some kind of connection problem, so it's not really a PostgreSQL issue, but more like a networking one.
Kind regards
Markus
Computec Media AG
Sitz der Gesellschaft und Registergericht: Fürth (HRB 8818)
Vorstandsmitglieder: Johannes S. Gözalan (Vorsitzender) und Niels Herrmann
Vorsitzender des Aufsichtsrates: Jürg Marquard
Umsatzsteuer-Identifikationsnummer: DE 812 575 276
---------------------------(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
