Re: Maximum Possible Insert Performance?

Поиск
Список
Период
Сортировка
От Dror Matalon
Тема Re: Maximum Possible Insert Performance?
Дата
Msg-id 20031126185421.GN30893@rlx11.zapatec.com
обсуждение исходный текст
Ответ на Re: Maximum Possible Insert Performance?  (William Yu <wyu@talisys.com>)
Список 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 по дате отправления:

Предыдущее
От: Roger Ging
Дата:
Сообщение: Followup - expression (functional) index use in joins
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Followup - expression (functional) index use in joins