Re: out of memory woes

"Angva" <angvaw(at)gmail(dot)com> writes:
> As I've mentioned in a few other posts, I run a daily job that loads
> large amounts of data into a Postgres database. It must run
> efficiently, so one of the tricks I do is run table loads, and commands
> such as cluster, in parallel. I am having a problem where my cluster
> job consistently fails with an out of memory error.

Could we see the actual error message? If it's a server-side error
then there should also be a memory context dump into the postmaster
log, which would be useful to see also. Lastly, please show the full
schema definition (including indexes) for the troublesome tables.

regards, tom lane