Re: Acclerating INSERT/UPDATE using UPS

Поиск

Список

Период

Сортировка

От	Chad Wagner
Тема	Re: Acclerating INSERT/UPDATE using UPS
Дата	12 февраля 2007 г. 20:00:44
Msg-id	81961ff50702121600p76d9b91w6354aba3e710ec8e@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Acclerating INSERT/UPDATE using UPS (Gene <genekhart@gmail.com>)
Список	pgsql-hackers

Дерево обсуждения

On 2/12/07, Gene <genekhart@gmail.com> wrote:

I was curious to see how postgres would perform with wal on a tmpfs vs disk here are some numbers I got from pgbench. Let me know if I did something stupid, this is the first time I've used pgbench. The wal on tmpfs method is not significantly faster.

tmpfs uses virtual memory, so it is likely hitting the disk. I would try and repeat your cases with ramfs, which uses real memory. Testing shows that just putting pg_xlog on ramfs yields a 30% boost in performance over disk with a stock configuration. So there is room for improvement, I am sure.

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Re: Acclerating INSERT/UPDATE using UPS