From: Shaun Thomas <sthomas@peak6.com>
To: Uwe Bartels <uwe.bartels@gmail.com>
Cc: Stephen Frost <sfrost@snowman.net>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: maintenance_work_mem + create index
Date: Thu, 24 Mar 2011 10:38:30 -0500
Message-ID: <4D8B6576.3090201@peak6.com> (raw)
In-Reply-To: <AANLkTimAc=Qn=xkZxY7Uyq+0PC-jV-L0FaVjVavzSJXr@mail.gmail.com>
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sthomas@peak6.com, uwe.bartels@gmail.com, sfrost@snowman.net
Subject: Re: maintenance_work_mem + create index
In-Reply-To: <4D8B6576.3090201@peak6.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox