Re: Postgres Benchmark Results

Поиск
Список
Период
Сортировка
От Guido Neitzer
Тема Re: Postgres Benchmark Results
Дата
Msg-id 37E3AB9B-77D7-4757-A379-29BE25F63533@event-s.net
обсуждение исходный текст
Ответ на Re: Postgres Benchmark Results  ("Jim C. Nasby" <decibel@decibel.org>)
Ответы Re: Postgres Benchmark Results  (Greg Smith <gsmith@gregsmith.com>)
Список pgsql-performance
Am 21.05.2007 um 15:01 schrieb Jim C. Nasby:

> I'd be willing to bet money that the drive is lying about commits/
> fsync.
> Each transaction committed essentially requires one revolution of the
> drive with pg_xlog on it, so a 15kRPM drive limits you to 250TPS.

Yes, that right, but if a lot of the transactions are selects, there
is no entry in the x_log for them and most of the stuff can come from
the cache - read from memory which is blazing fast compared to any
disk ... And this was a pg_bench test - I don't know what the
benchmark really does but if I remember correctly it is mostly reading.

cug



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

Предыдущее
От: PFC
Дата:
Сообщение: Re: Postgres Benchmark Results
Следующее
От: Rich
Дата:
Сообщение: Re: Postgres Benchmark Results