Re: Maximum Possible Insert Performance?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Maximum Possible Insert Performance?
Дата
Msg-id 16109.1069869356@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Maximum Possible Insert Performance?  (William Yu <wyu@talisys.com>)
Ответы Re: Maximum Possible Insert Performance?
Список pgsql-performance
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.

            regards, tom lane

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

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: why index scan not working when using 'like'?
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: expression (functional) index use in joins