Re: problem with large maintenance_work_mem settings and

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: problem with large maintenance_work_mem settings and
Дата
Msg-id 14703.1141832709@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: problem with large maintenance_work_mem settings and  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Ответы Re: problem with large maintenance_work_mem settings and  (Simon Riggs <simon@2ndquadrant.com>)
Re: problem with large maintenance_work_mem settings and  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Список pgsql-hackers
Дерево обсуждения 
Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
> CREATE INDEX on a 1,8B row table (5 int columns - index created on the 
> first row about 300M distinct values):

> before: 11h 51min
> after: 3h 11min(!)

Cool.  Does it seem to be I/O bound now?  Would you be willing to do it
over with oprofile turned on?
        regards, tom lane

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

Предыдущее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: problem with large maintenance_work_mem settings and
Следующее
От: David Fetter
Дата:
Сообщение: Add switches for DELIMITER and NULL in pg_dump COPY