Re: What's using all my RAM?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: adey <adey11(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, "PostgreSQL Admin" <postgres(at)productivitymedia(dot)com>, postgresql-l <postgresql-l(at)Groups(dot)ittoolbox(dot)com>
Subject: Re: What's using all my RAM?
Date: 2006-08-02 04:37:47
Message-ID: 9130.1154493467@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

adey <adey11(at)gmail(dot)com> writes:
> Please could someone tell me how to discover what is using all of my RAM?
> I am trying to run a vacuum against Postgres, but it fails immediately
> with:-

> "ERROR: out of memory
> DETAIL: Failed on request of size 1073741820."

I'd bet lunch that this is a corrupt-data problem, not an out-of-memory
problem --- specifically, a bad value in a field length word. See the
archives for many prior examples.

> Postgres v7.4.2 (upgrade underway)

Yipes :-(

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Fuhr 2006-08-02 04:47:55 Re: What's using all my RAM?
Previous Message adey 2006-08-02 04:09:43 What's using all my RAM?