Skip site navigation (1) Skip section navigation (2)

Re: Maximum Possible Insert Performance?

From: Dror Matalon <dror(at)zapatec(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Maximum Possible Insert Performance?
Date: 2003-11-26 18:54:21
Message-ID: 20031126185421.GN30893@rlx11.zapatec.com (view raw or flat)
Thread:
Lists: 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(at)talisys(dot)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

In response to

pgsql-performance by date

Next:From: Richard HuxtonDate: 2003-11-26 19:12:01
Subject: Re: Followup - expression (functional) index use in joins
Previous:From: Roger GingDate: 2003-11-26 18:39:28
Subject: Followup - expression (functional) index use in joins

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group