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

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 se