Re: [GENERAL] pqReadData() -- backend closed the channel unexpect edly. - Mailing list pgsql-general

Thanks again, Jackson, but your query is not right :(
Here is a sample output:

your query:

 SELECT o.origine, sum(o.bytes), sum(d.bytes), '09/02/1999
00:59:59'::datetime
   FROM day o, day d
where o.origine=d.destinazione
and o.origine << '194.74.133.0/24'
and o.when between '09/02/1999 00:00:01' and '09/02/1999 00:59:59'
and d.when between '09/02/1999 00:00:01' and '09/02/1999 00:59:59'
  GROUP BY o.origine,4;

result (only for host 194.74.133.11, query is too long):

 194.74.133.11|18569856|13493249|09/02/1999 00:59:59.00 MET

simple query to check first sum:

SELECT o.origine, sum(o.bytes)
   FROM day o
where o.origine = '194.74.133.11'
and o.when between '09/02/1999 00:00:01' and '09/02/1999 00:59:59'
  GROUP BY o.origine;

194.74.133.11|250944

Huge difference! Moreover, your query is slow, much much slower than two
separate queries. I would have used it though, if it worked. Postgresql
keeps crashing on my loop. :(

Thanks

L.