Re: Server stops responding in every week

Andy,

> Does PG start swapping to disk?

Earlier I used Stack builder to optimize Postgres as dedicated server. MS
SQL server was installed afterwards.
In this case message
"System is out of virtual memory". Windows is increasing the swap file size.
During this memory requests from applications may fail.

occurs in server screen if Postgres stops responding.

I re-ran Stack builder to optimize conf file as application server and
uninstalled MS SQL server.
After that I havent noticed any swapping.

> Does ram using increase over the week?
> Have you looked at pg_stat_activity and pg_locks?
> Do you see "Idle in transaction" (probably in task manager)?

I havent looked into them.

How to automatically re-start postgres service in every night ? Or is it
better to switch to 32bit server?

Andrus.