Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
Дата
Msg-id 200503082300.47085.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Tom,

> Huh?  Doubled compared to what?

Compared to how much data writing I can do to the database when pgsql_tmp
isn't engaged.

In other words, when pgsql_tmp isn't being written, database writing is 9mb/s.
When pgsql_tmp gets engaged, that drops to 4mb/s.

Alternatively, the WAL drive, which is the same hardware, will write at
10mb/s.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: index scan on =, but not < ?
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: pl/pgsql faster than raw SQL?