On Mon, 30 Jan 2006, Patrick Rotsaert wrote:
> Problem:
> -------
> Executing a select query causes the backend to crash. This is the output
> from the psql frontend:
>
> pointspp=# select trid, count(*) from pptran group by trid having
> count(*)
> > 1;
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
> !>
One question is what does the explain (without analyze) plan look like for
the above and are the row estimates valid in the case of one of the hash
plans.
Failing that, how many rows should the above return?
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
