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

Поиск
Список
Период
Сортировка
От Ivan Voras
Тема Re: Inserting 8MB bytea: just 25% of disk perf used?
Дата
Msg-id hj4jil$rg2$2@ger.gmane.org
обсуждение исходный текст
Ответ на Re: Inserting 8MB bytea: just 25% of disk perf used?  ("fkater@googlemail.com" <fkater@googlemail.com>)
Список pgsql-performance
On 01/19/10 14:36, fkater@googlemail.com wrote:
> 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?

It seems so - if you are writing constantly then you will probably get
lower but more long-term-stable performance from a smaller number of WAL
logs.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)
Следующее
От: "Ing. Marcos L. Ortiz Valmaseda"
Дата:
Сообщение: Re: renice on an I/O bound box