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