Обсуждение: Memory exhaustion
marketingbyoffice is a view. I start the postmaster, then issue the following query in psql console. It goes to sleep forever:-) Why? The log is as follows: ------log ----- 010404.13:49:14.612 [1352] StartTransactionCommand 010404.13:49:14.612 [1352] query: SELECT * INTO TEMP TABLE marketingbylocation FROM marketingbyoffice; 010404.13:49:14.624 [1352] ProcessQuery 010404.13:52:28.691 [1352] FATAL 1: Memory exhausted in AllocSetAlloc() 010404.13:52:32.568 [1352] AbortCurrentTransaction __________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/
Srikanth Rao <srirao_us@yahoo.com> wrote: >marketingbyoffice is a view. How is it defined? [*] >010404.13:52:28.691 [1352] FATAL 1: Memory exhausted in AllocSetAlloc() Have you followed the suggestion at http://www.postgresql.org/docs/faq-english.html#4.19 ? HTH, Ray [*] Not just out of idle curiosity; I'm aware of at least one operator/function that can trigger this behaviour in 7.0.3; see http://bugs.debian.org/92705 -- What is this talk of software 'releases'? Klingons do not 'release' software; our software ESCAPES, leaving a bloody trail of designers and quality assurance people in its wake!