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