From: | Uwe Bartels <uwe(dot)bartels(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | maintenance_work_mem + create index |
Date: | 2011-03-24 13:56:35 |
Message-ID: | AANLkTik1GzFrcAaYNPDxLgc7LFcfPK6wx0rEmtKgp2OO@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi,
I see my application creating temporary files while creating an index.
LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp7076.0", size 779853824
STATEMENT: CREATE INDEX IDX_LPA_LINKID ON NNDB.LPA (LINK_ID);
So I checked this again and raised afterwards maintenance_work_mem step by
step up 64GB.
I logged in via psql, run the following statements
set maintenance_work_mem = '64GB';
CREATE INDEX IDX_LPA_LINKID ON NNDB.LPA (LINK_ID);
But still I get that evil message in the log file about creating a temporary
file.
I also raised work_mem in my session up to 32GB - again without changing the
behavior.
According to the postgres docs
http://www.postgresql.org/docs/8.4/static/populate.html#POPULATE-WORK-MEMthis
is supposed to help.
Any ideas?
I'm running postgres 8.4 64 bit on Linux from an enterprisedb package.
# file /var/lib/pgsql/bin/postgres
/var/lib/pgsql/bin/postgres: ELF 64-bit LSB executable, x86-64, version 1
(SYSV), for GNU/Linux 2.4.0, dynamically linked (uses shared libs), not
stripped
Best Regards,
Uwe
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2011-03-24 14:13:03 | Re: maintenance_work_mem + create index |
Previous Message | Achilleas Mantzios | 2011-03-24 12:07:29 | Re: pg9.0.3 explain analyze running very slow compared to a different box with much less configuration |