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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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