Re: Inserting 8MB bytea: just 25% of disk perf used?

Поиск
Список
Период
Сортировка
От fkater@googlemail.com
Тема Re: Inserting 8MB bytea: just 25% of disk perf used?
Дата
Msg-id 20100119133630.GD2200@comppasch2
обсуждение исходный текст
Ответ на Re: Inserting 8MB bytea: just 25% of disk perf used?  (Ivan Voras <ivoras@freebsd.org>)
Ответы Re: Inserting 8MB bytea: just 25% of disk perf used?  (Ivan Voras <ivoras@freebsd.org>)
Список pgsql-performance
Ivan Voras:

> [I just skimmed this thread - did you increase the number of WAL logs to
> something very large, like 128?]

Yes, I tried even more.

I will be writing data quite constantly in the real scenario
later. So I wonder if increasing WAL logs will have a
positive effect or not: AFAIK when I increase it, the
duration after the max is hit will be longer then (which is
not acceptable in my case).

Could anyone confirm if I got it right?

 Felix


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

Предыдущее
От: Willy-Bas Loos
Дата:
Сообщение: renice on an I/O bound box
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)