| From: | "carl garland" <carlhgarland(at)hotmail(dot)com> |
|---|---|
| To: | doug(at)wireboard(dot)com, tgl(at)sss(dot)pgh(dot)pa(dot)us |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Backends dying due to memory exhaustion--I'm stonkered |
| Date: | 2001-01-27 13:12:18 |
| Message-ID: | F11dZjfNLnlyg35sQtg00000903@hotmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>
>Waiting for the next crash with anticipation...
Since you said you are running ACS is here you may as well want to
set the param Verbose to True in your db pool which will log all queries to
the db in the access log. Then when it crashes during
normal execution you can simple determine the offending query. Of
course this may create a copius log file on an heavily accessed site and you
may wish to roll the log more freqently. Also wont may not
be related or help the vacuum situation.
Best Regards,
Carl Garland
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc SCHAEFER | 2001-01-27 14:20:48 | Search engine doesn't work |
| Previous Message | Adriaan Joubert | 2001-01-27 12:21:23 | www.postgresql.de |