Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks
Дата
Msg-id 9413.1082661771@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks  (Eduardo Almeida <edalmeida@yahoo.com>)
Список pgsql-performance
Markus Bertheau <twanger@bluetwanger.de> writes:
>> You could probably improve the index-create time by temporarily
>> increasing sort_mem.  It wouldn't be unreasonable to give CREATE INDEX
>> several hundred meg to work in.  (You don't want sort_mem that big
>> normally, because there may be many sorts happening in parallel,
>> but in a data-loading context there'll just be one active sort.)

> Doesn't this provide a reason for CREATE INDEX not to honour sort_mem?

Already done for 7.5.

http://archives.postgresql.org/pgsql-committers/2004-02/msg00025.php

            regards, tom lane

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Wierd context-switching issue on Xeon patch for 7.4.1
Следующее
От: Pailloncy Jean-Gérard
Дата:
Сообщение: Re: 225 times slower