Re: array_agg crash? - Mailing list pgsql-general

From Tom Lane
Subject Re: array_agg crash?
Date
Msg-id 13990.1248190927@sss.pgh.pa.us
Whole thread Raw
In response to Re: array_agg crash?  ("Chris Spotts" <rfusca@gmail.com>)
Responses Re: array_agg crash?
List pgsql-general
"Chris Spotts" <rfusca@gmail.com> writes:
> That seems to have fixed it in the sense that it doesn't crash, but I killed
> it after 15 minutes and no results...rather I tried to kill it, but it looks
> like I'm going to have to -9 it...

How big were the arrays you were trying to push around here?  I tried
interrupting a similar query and it came right back; but if you were
building some really enormous arrays I could see the final array
build loop taking awhile, and there's no CHECK_FOR_INTERRUPTS in it...

            regards, tom lane

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: First query very slow. Solutions: memory, or settings, or SQL?
Next
From: David Kerr
Date:
Subject: Re: killing processes