As long as there are no nulls allowed in column 'dst' the
select src,dst,count(dst) from ...
should retrieve the same result.
Try it. It should run faster anyway.
Maybe there are other ways to word your query, but without
more knowledge about your table structure and intentions
I can't tell you what.
Alternatively, you may want to report your error to the
[HACKERS] mailing list - there you might even find more
detailed support.
Regards, Christoph
>
> Hi all.
>
> I sent this once before, but didn't see it appear on the list... So here we
> go again...
>
> I have a large query that I'm trying to run, but it never finishes. I
> get an error message and it quits.
>
> I'm doing:
>
> psql ids -c 'select src,dst,count(*) from brick* where src_port=135
> group by src,dst' > /tmp/135.dat
>
> and I get:
>
> ERROR: out of free buffers: time to abort !
>
> Any ideas on how to get this query to run?
>
> Thanx,
> Mike Diehl.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>