Re: is there any backend (server) timeout undocumented?

On Sat, May 25, 2002 at 07:39:02PM +0100, NunoACHenriques wrote:
>     Hi!
>
>     I have sended the message below to pgadmin-support (by mistake I
> think) and to pgsql-hackers but receive no answers... I hope you can help me
> on this...
>
>     Is there any server timeout that is undocumented?
>
>     I've issued a query like the one below and the server timed out after
> 120min (+/-). The query "construct_warehouse()" can last well above the
> 120min because it fills a table with millions of tuples... I really believe
> in PostgreSQL! :-)

Sounds to me like you're running out of memory. What version of postgres are
you using? What does ps aux show while the query is running.

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Canada, Mexico, and Australia form the Axis of Nations That
> Are Actually Quite Nice But Secretly Have Nasty Thoughts About America