Re: Problems with unconstrained join - Mailing list pgsql-general

From Tom Lane
Subject Re: Problems with unconstrained join
Date
Msg-id 23360.1015434403@sss.pgh.pa.us
Whole thread Raw
In response to Problems with unconstrained join  (Oliver Elphick <olly@lfix.co.uk>)
Responses Re: Problems with unconstrained join  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-general
Oliver Elphick <olly@lfix.co.uk> writes:
> [ Cartesian product = 30,052,324 rows ]

> bray=# select p.id from product as p, stock;
> server sent data ("D" message) without prior row description ("T" message)
> server sent data ("D" message) without prior row description ("T" message)

libpq does not respond very gracefully to running out of memory for a
query result.  It doesn't crash exactly, but it loses track of what's
coming in, after which you get all these useless error messages.  Feel
free to fix it ...

            regards, tom lane

pgsql-general by date:

Previous
From: David Griffiths
Date:
Subject: Re: Problems with unconstrained join
Next
From: "Gregory Wood"
Date:
Subject: Re: joins?