Re: BUG #2225: Backend crash -- BIG table

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?