Re: Maximum Possible Insert Performance?

Поиск
Список
Период
Сортировка
От William Yu
Тема Re: Maximum Possible Insert Performance?
Дата
Msg-id bq2pu0$e5$1@news.hub.org
обсуждение исходный текст
Ответ на Re: Maximum Possible Insert Performance?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Maximum Possible Insert Performance?  (Dror Matalon <dror@zapatec.com>)
Список pgsql-performance
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.


В списке pgsql-performance по дате отправления:

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