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

Re: Maximum Possible Insert Performance?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: William Yu <wyu(at)talisys(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Maximum Possible Insert Performance?
Date: 2003-11-26 17:55:56
Message-ID: 16109.1069869356@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
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.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: William YuDate: 2003-11-26 18:03:47
Subject: Re: Maximum Possible Insert Performance?
Previous:From: Richard HuxtonDate: 2003-11-26 17:52:30
Subject: Re: expression (functional) index use in joins

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