From: | Shaun Thomas <sthomas(at)peak6(dot)com> |
---|---|
To: | Uwe Bartels <uwe(dot)bartels(at)gmail(dot)com> |
Cc: | Stephen Frost <sfrost(at)snowman(dot)net>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: maintenance_work_mem + create index |
Date: | 2011-03-24 15:38:30 |
Message-ID: | 4D8B6576.3090201@peak6.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On 03/24/2011 10:28 AM, Uwe Bartels wrote:
> OK. sounds promising. On my machine this looks similar.
> I'll try this.
I just realized I may have implied that DBSHM automatically defaults to
/db/shm/pgsql_tmp. It dosen't. I also have this at the very top of our
/etc/init.d/postgresql script:
if [ -f /etc/sysconfig/postgresql ]; then
source /etc/sysconfig/postgresql
fi
DBSHM=${DBSHM:-/dev/shm/pgsql_tmp}
PGDATA=${PGDATA:-"/db/data/pgdata"}
PGUSER=${PGUSER:-postgres}
DBSHM doesn't exist, and the other vars will probably be empty unless
you set them in the sysconfig file. What I meant was that /dev/shm
automatically exists on our Linux box and we make use of it. :)
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 800 | Chicago IL, 60604
312-676-8870
sthomas(at)peak6(dot)com
______________________________________________
See http://www.peak6.com/email_disclaimer.php
for terms and conditions related to this email
From | Date | Subject | |
---|---|---|---|
Next Message | Euler Taveira de Oliveira | 2011-03-24 17:35:02 | Re: maintenance_work_mem + create index |
Previous Message | Uwe Bartels | 2011-03-24 15:28:54 | Re: maintenance_work_mem + create index |