Re: [ADMIN] hung postmaster when client machine dies?

2004-05-08 Thread Peter Galbavy
Goulet, Dick wrote: Hope you don't mind if I disagree. Most OS's that have a tcp/ip layer also have a parameter therein called tcp_keep_alive. They also set this parameter to infinity. The purpose of tcp_keep_alive is to have the OS kernel periodically verify that all tcp/ip connections it

Re: [ADMIN] cast not IMMUTABLE?

2004-05-08 Thread Stephan Szabo
On Fri, 7 May 2004, Gaetano Mendola wrote: Hi all, I have a table with ~ 3e+6 rows on it. I do select on this table in this way: (1) select * from user_logs where login_time::date = now()::date; consider that login_time is a TIMESTAMPTZ with an index on it. If I use the select in