pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Memory exhaustion 2+ messages / 2 participants [nested] [flat]
* Memory exhaustion @ 2001-04-04 18:45 Srikanth Rao <srirao_us@yahoo.com> 2001-04-04 20:33 ` Re: Memory exhaustion J.H.M. Dassen (Ray) <jdassen@cistron.nl> 0 siblings, 1 reply; 2+ messages in thread From: Srikanth Rao @ 2001-04-04 18:45 UTC (permalink / raw) To: pgsql-sql 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/ ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Memory exhaustion 2001-04-04 18:45 Memory exhaustion Srikanth Rao <srirao_us@yahoo.com> @ 2001-04-04 20:33 ` J.H.M. Dassen (Ray) <jdassen@cistron.nl> 0 siblings, 0 replies; 2+ messages in thread From: jdassen@cistron.nl @ 2001-04-04 20:33 UTC (permalink / raw) To: pgsql-sql 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! ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-04-04 20:33 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2001-04-04 18:45 Memory exhaustion Srikanth Rao <srirao_us@yahoo.com> 2001-04-04 20:33 ` J.H.M. Dassen (Ray) <jdassen@cistron.nl>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox