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 16320.1110343078@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:
>> AFAIR that's just fwrite() ...

> Well, are there any hacks to speed it up?   It's about doubling the amount of
> time it takes to create an index on a very large table.

Huh?  Doubled compared to what?

            regards, tom lane

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

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