| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Brian Wong <bwong(at)imageworks(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Getting "Out of memory" errors on server 9.1.9 |
| Date: | 2013-08-22 23:16:55 |
| Message-ID: | 27357.1377213415@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Brian Wong <bwong(at)imageworks(dot)com> writes:
> I'm getting a "Out of memory" error on a 9.1.9 server. What do these lines
> in the log mean? ~ Brian
It's a memory usage map. Your problem is evidently here:
> MessageContext: 3046113280 total in 374 blocks; 24584 free (5 chunks);
> 3046088696 used
As far as I recall at the moment, MessageContext is used to parse,
analyze, and possibly to plan an incoming query. So the short answer is
that you're trying to run a query that's too long and/or too complicated.
We'd need a lot more details before suggesting how you might work around
that.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2013-08-23 08:14:43 | Re: several questions about pg_dumpall, pg_start_backup, pg_basebackup and WAL |
| Previous Message | Brian Wong | 2013-08-22 22:53:57 | Getting "Out of memory" errors on server 9.1.9 |