Search Postgresql Archives

Re: out of memory woes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Angva" <angvaw@xxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux