Re: [Bizgres-general] Re: faster INSERT with possible

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [Bizgres-general] Re: faster INSERT with possible
Дата
Msg-id 13604.1122511265@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [Bizgres-general] Re: faster INSERT with possible  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
> RIght.  The problem is bypassing WAL for loading new "scratch" tables which
> aren't TEMPORARY tables.   We need to do this for multi-threaded ETL, since:
> a) Temp tables can't be shared by several writers, and
> b) you can't index a temp table.

This may not matter given point (a), but: point (b) is completely wrong.

            regards, tom lane

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Performance problems testing with Spamassassin 3.1.0 Bayes module.
Следующее
От: Matthew Schumacher
Дата:
Сообщение: Re: Performance problems testing with Spamassassin 3.1.0