Re: What's using all my RAM?

adey <adey11@gmail.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