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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
Дата
Msg-id 16215.1110342464@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
> Maybe I'm not an idiot (really!)  even with almost 2GB of maintenance_mem, PG
> still writes to pgsql_tmp no faster than 2MB/s.    I think there may be an
> artificial bottleneck there.  Question is, PostgreSQL, OS or hardware?

AFAIR that's just fwrite() ...

            regards, tom lane

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: index scan on =, but not < ?
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?