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
Ответ на
Список
Дерево обсуждения
Inserting 8MB bytea: just 25% of disk perf used? "fkater@googlemail.com" <fkater@googlemail.com>
Re: Inserting 8MB bytea: just 25% of disk perf used? Aidan Van Dyk <aidan@highrise.ca>
Re: Inserting 8MB bytea: just 25% of disk perf used? "fkater@googlemail.com" <fkater@googlemail.com>
Re: Inserting 8MB bytea: just 25% of disk perf used? "Fernando Hevia" <fhevia@ip-tel.com.ar>
Re: Inserting 8MB bytea: just 25% of disk perf used? Matthew Wakeling <matthew@flymine.org>
Re: Inserting 8MB bytea: just 25% of disk perf used? "fkater@googlemail.com" <fkater@googlemail.com>
Re: Inserting 8MB bytea: just 25% of disk perf used? Pierre Frédéric Caillaud<lists@peufeu.com>
Re: Inserting 8MB bytea: just 25% of disk perf used? "fkater@googlemail.com" <fkater@googlemail.com>
Re: Inserting 8MB bytea: just 25% of disk perf used? "fkater@googlemail.com" <fkater@googlemail.com>
Re: Inserting 8MB bytea: just 25% of disk perf used? "fkater@googlemail.com" <fkater@googlemail.com>
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? "fkater@googlemail.com" <fkater@googlemail.com>
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? Scott Carey <scott@richrelevance.com>
Re: Inserting 8MB bytea: just 25% of disk perf used? "fkater@googlemail.com" <fkater@googlemail.com>
Re: Inserting 8MB bytea: just 25% of disk perf used? "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Inserting 8MB bytea: just 25% of disk perf used? Richard Huxton <dev@archonet.com>
Re: Inserting 8MB bytea: just 25% of disk perf used? Scott Carey <scott@richrelevance.com>
Re: Inserting 8MB bytea: just 25% of disk perf used? Florian Weimer <fweimer@bfk.de>
Re: Inserting 8MB bytea: just 25% of disk perf used? "fkater@googlemail.com" <fkater@googlemail.com>
Re: Inserting 8MB bytea: just 25% of disk perf used? Florian Weimer <fweimer@bfk.de>
Re: Inserting 8MB bytea: just 25% of disk perf used? Matthew Wakeling <matthew@flymine.org>
Re: Inserting 8MB bytea: just 25% of disk perf used? "fkater@googlemail.com" <fkater@googlemail.com>
Re: Inserting 8MB bytea: just 25% of disk perf used? Matthew Wakeling <matthew@flymine.org>
Re: Inserting 8MB bytea: just 25% of disk perf used? "fkater@googlemail.com" <fkater@googlemail.com>
Re: Inserting 8MB bytea: just 25% of disk perf used? Florian Weimer <fweimer@bfk.de>
Re: Inserting 8MB bytea: just 25% of disk perf used? Merlin Moncure <mmoncure@gmail.com>
Re: Inserting 8MB bytea: just 25% of disk perf used? Dave Crooke <dcrooke@gmail.com>
Re: Inserting 8MB bytea: just 25% of disk perf used? "fkater@googlemail.com" <fkater@googlemail.com>
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? "fkater@googlemail.com" <fkater@googlemail.com>
Re: Inserting 8MB bytea: just 25% of disk perf used? Pierre Frédéric Caillaud<lists@peufeu.com>
Re: Inserting 8MB bytea: just 25% of disk perf used? "fkater@googlemail.com" <fkater@googlemail.com>
Re: Inserting 8MB bytea: just 25% of disk perf used? Pierre Frédéric Caillaud<lists@peufeu.com>
Re: Inserting 8MB bytea: just 25% of disk perf used? "fkater@googlemail.com" <fkater@googlemail.com>
Re: Inserting 8MB bytea: just 25% of disk perf used? Magnus Hagander <magnus@hagander.net>
Re: Inserting 8MB bytea: just 25% of disk perf used? Pierre Frédéric Caillaud<lists@peufeu.com>
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
Дата:
FAQ