Re: [GENERAL] huge backend processes

1999-08-18 Thread Bruce Momjian
> > maybe i'm doing something wrong here: > > CREATE TABLE samples > ( > mark abstime, > subnetinet, > bytes_in float8, > bytes_out float8 > ); > CREATE INDEX samples_mark ON samples (mark); > > --- fill it with lots and lots of data > > BEGIN WORK; > DECLARE mycurs CURSO

Re: [GENERAL] huge backend processes

1999-08-18 Thread Jim Mercer
> if i revert my code to (note: less the DATE_PART conversion): > > DECLARE mycurs CURSOR FOR >SELECT mark, subnet, bytes_in, bytes_out >FROM samples >WHERE mark >= 'epoch or another date'::abstime; > > it works fine. as a followup, if i use: DECLARE mycurs CURSOR FOR SELECT mar