Re: Maximum Possible Insert Performance?

From: William Yu <wyu(at)talisys(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Maximum Possible Insert Performance?
Date: 2003-11-26 18:03:47
Message-ID: bq2pu0$e5$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Roger Ging 2003-11-26 18:39:28 Followup - expression (functional) index use in joins
Previous Message Tom Lane 2003-11-26 17:55:56 Re: Maximum Possible Insert Performance?