no swap space
От | Mark Wilson |
---|---|
Тема | no swap space |
Дата | |
Msg-id | 199902111817.NAA03273@sundog.larc.nasa.gov обсуждение исходный текст |
Список | pgsql-general |
Hello, I have a large data set stored using version 6.4.2 on a Sun Ultra 30 (Solaris 2.6 - 384MB RAM). While trying to preform a somewhat complex select on one of the larger tables from the psql> command promplt, I am given the following error message then dumped out out psql: pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. We have lost the connection to the backend, so further processing is impossible. Terminating. If I try the same query from a cgi script written in perl, the script comes back empty and this warningappears on my console screen: WARNING: Sorry, no swap space to grow stack for pid 15195 (postgres) The swap space on the system I'm using looks to be around 275MB and it remains at about 1% capacity during the operation that bombed. I've looked around the mail archives and have not found any similar problems or solutions. Does anyone have any ideas? Thanks! -Mark. --- fax: (757)825-8659 Mark Wilson voice: (757)827-4631 Analytical Services & Materials, Inc. email: m.r.wilson@larc.nasa.gov
В списке pgsql-general по дате отправления: