Quick Postgres Question

If I have 30-40 Win 7 pc’s log in and listen for 3 hrs is there a timing out issue? Is there an issue with 30-40 connections?

Each Win 7 pc’s will get 2 recordsets upon connection.

Each Win 7 pc’s might push an announcement 2 times in the 3 hrs. So each of the machine may have to get a recordset for the announcements a max of 100 times in the 3 hours.

By “listen” you mean to the notification system, I guess, right? Anyway, your numbers sound as if the server will be bored most of the time. As for the timeouts, make sure you read http://www.postgresql.org/docs/current/static/runtime-config-connection.html and there especially the tcp_keepalives-settings.

Thanks.