Re: Maximum Possible Insert Performance? - Mailing list pgsql-performance

From Dror Matalon
Subject Re: Maximum Possible Insert Performance?
Date
Msg-id 20031126185421.GN30893@rlx11.zapatec.com
Whole thread Raw
In response to Re: Maximum Possible Insert Performance?  (William Yu <wyu@talisys.com>)
List pgsql-performance
But the permissions of the base ramdisk might be wrong. I'd su to the
user that you run postgres as (probably postgres), and make sure that
you can go to the directory where the log and the database files are and
make sure you can see the files.

On Wed, Nov 26, 2003 at 10:03:47AM -0800, William Yu wrote:
> Tom Lane wrote:
> >William Yu <wyu@talisys.com> writes:
> >
> >>I then tried to put the WAL directory onto a ramdisk. I turned off
> >>swapping, created a tmpfs mount point and copied the pg_xlog directory
> >>over. Everything looked fine as far as I could tell but Postgres just
> >>panic'd with a "file permissions" error. Anybody have thoughts to why
> >>tmpfs would not work?
> >
> >
> >I'd say you got the file or directory ownership or permissions wrong.
>
> I did a mv instead of a cp which duplicates ownership & permissions exactly.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
Dror Matalon
Zapatec Inc
1700 MLK Way
Berkeley, CA 94709
http://www.fastbuzz.com
http://www.zapatec.com

pgsql-performance by date:

Previous
From: Roger Ging
Date:
Subject: Followup - expression (functional) index use in joins
Next
From: Richard Huxton
Date:
Subject: Re: Followup - expression (functional) index use in joins