"Chris Hoover" <revoohc(at)gmail(dot)com> writes:
> maintenance_work_mem = 1048576 (I have 9GB ram on this server).
You might have that much RAM, but I wonder how much of it the kernel
will give to any one process. Did you check the ulimit settings the
postmaster is running under? Is it possibly a 32-bit rather than
64-bit build of Postgres?
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Andrew Sullivan||Date: 2007-05-31 14:43:12|
|Subject: Re: High Avaliable in the PostgreSQL.|
|Previous:||From: Chris Hoover||Date: 2007-05-31 14:07:14|
|Subject: Re: Fwd: Out of Memory on Reindex|