Andy,
>> How to automatically re-start postgres service in every night ? Or is it
>> better to switch to 32bit server?
>
> Neither. You need to fix the problem.
How to configure postgres so that freeze issue can addressed ?
E.q. if query runs more that 60 seconds, postgres dumps its status and long
query reason .
How to implement this ?
No idea can log_statement=all help.
Andrus.