| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | NunoACHenriques <nach(at)fct(dot)unl(dot)pt> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: is there any backend (server) timeout undocumented? |
| Date: | 2002-05-28 02:22:59 |
| Message-ID: | 20020528122259.A4608@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)svana(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-05-28 02:44:03 | Re: How to cripple a postgres server |
| Previous Message | Stephen Robert Norris | 2002-05-28 02:04:50 | Re: How to cripple a postgres server |