Message-ID: <4D8B6576.3090201@peak6.com>
Date: Thu, 24 Mar 2011 10:38:30 -0500
From: Shaun Thomas <sthomas@peak6.com>
Reply-To: sthomas@peak6.com
Organization: Peak6
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.2.7) Gecko/20100720 Lightning/1.0b2 Thunderbird/3.1.1
MIME-Version: 1.0
To: Uwe Bartels <uwe.bartels@gmail.com>
CC: Stephen Frost <sfrost@snowman.net>, "pgsql-performance@postgresql.org"
	<pgsql-performance@postgresql.org>
Subject: Re: maintenance_work_mem + create index
References: <AANLkTik1GzFrcAaYNPDxLgc7LFcfPK6wx0rEmtKgp2OO@mail.gmail.com>
	<20110324141303.GE4116@tamriel.snowman.net>
	<AANLkTikQO+y2nWz4SjjUMKkGDCVFFL0Z_8bu9poUyk=9@mail.gmail.com>
	<4D8B5FB9.7030704@peak6.com>
	<AANLkTimAc=Qn=xkZxY7Uyq+0PC-jV-L0FaVjVavzSJXr@mail.gmail.com>
In-Reply-To: <AANLkTimAc=Qn=xkZxY7Uyq+0PC-jV-L0FaVjVavzSJXr@mail.gmail.com>
Content-Type: text/plain; charset="ISO-8859-1"; format=flowed
content-transfer-encoding: 7bit

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@peak6.com

______________________________________________

See  http://www.peak6.com/email_disclaimer.php
for terms and conditions related to this email