| From: | Srikanth Rao <srirao_us(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Memory exhaustion |
| Date: | 2001-04-04 18:45:09 |
| Message-ID: | 20010404184509.25903.qmail@web6303.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Poet/Joshua Drake | 2001-04-04 18:53:24 | [pgsql-general] Baffling Performance |
| Previous Message | jkakar | 2001-04-04 17:57:38 | Need to do an ALTER TABLE. |