Re: hanging processes

> > With a win32 server & XP clients, if the client is killed=20
> with a hard=20
> > reset i.e. pull out power cord, the server does not=20
> recognize that the=20
> > connection has been broken in pg_stat_activity and does not=20
> clean up=20
> > various things such as user_locks and presumably entries in=20
> pg_listener.
> > A manual kill via pg_ctl is required from that point.
>=20
> Did you wait for the TCP KEEPALIVE timeout interval?

Which, if you didn't know it already, is two hours on Windows.

//Magnus

---------------------------(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