Re: bulk loading table via join of 2 large staging tables

Поиск
Список
Период
Сортировка
От Seb
Тема Re: bulk loading table via join of 2 large staging tables
Дата
Msg-id 87mwjdf2nk.fsf@kolob.subpolar.dyndns.org
обсуждение исходный текст
Ответ на Re: bulk loading table via join of 2 large staging tables  (Brent Wood <Brent.Wood@niwa.co.nz>)
Список pgsql-general
Дерево обсуждения 
On Tue, 31 Dec 2013 02:23:30 +0000,
Brent Wood <Brent.Wood@niwa.co.nz> wrote:

> This should help...  In each temporary table convert the time parts to
> a timestamp, then create an index on each of these, then join on the
> timestamp.

[...]

Thank you, these were very useful suggestions, and lead to a very
efficient table loading.

Cheers,

--
Seb

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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Why the size (PQ_BUFFER_SIZE) of backend send buffers is 8192 ?
Следующее
От: Moshe Jacobson
Дата:
Сообщение: Suddenly all tables were gone