"Chris Hoover" <[EMAIL PROTECTED]> writes:
> This is on a 32bit dual HT Xeon system using the official rpms.
Um. I suspect you can't usefully set maintenance_work_mem as high as
1Gb in a 32-bit environment. Last I heard, the max address space
available to userland in 32-bit Linux is 3Gb (the ker
Sorry for not providing that info Here are the ulimits for my postgres
account:
[EMAIL PROTECTED] ~]$ ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked
"Chris Hoover" <[EMAIL PROTECTED]> 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-b
maintenance_work_mem = 1048576 (I have 9GB ram on this server).
Chris
On 5/30/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Chris Hoover" <[EMAIL PROTECTED]> writes:
> I am getting the following error when trying to run a reindex on one of
my
> databases.
> reindexdb: reindexing of database "xxx"
"Chris Hoover" <[EMAIL PROTECTED]> writes:
> I am getting the following error when trying to run a reindex on one of my
> databases.
> reindexdb: reindexing of database "xxx" failed: ERROR: out of memory
> DETAIL: Failed on request of size 268435456.
> Can someone advise on what memory paramete
Chris Hoover wrote:
Any ideas?
Drop it and try to recreate it. As far as the parameter it is
maintenance_work_mem but that should spill to disk which means you ran
out of actual memory too.
Joshua D. Drake
P.S. You *need* to upgrade to 8.1.9
-- Forwarded message --
From:
Any ideas?
-- Forwarded message --
From: Chris Hoover <[EMAIL PROTECTED]>
Date: May 29, 2007 11:36 AM
Subject: Out of Memory on Reindex
To: "pgsql-admin@postgresql.org"
I am getting the following error when trying to run a reindex on one of my
databases.
reindexdb: reindexing o
