Re: Efficient Way to Merge Two Large Tables

Поиск
Список
Период
Сортировка
Искать
От
Daniel Verite
Тема
Re: Efficient Way to Merge Two Large Tables
Дата
Msg-id
8084cdb2-6e87-408c-b48e-3ffb0ca82022@mm
Ответ на
Список
Дерево обсуждения
Efficient Way to Merge Two Large Tables Joshua Rubin <jrubin@esoft.com>
Re: Efficient Way to Merge Two Large Tables Julian Mehnle <julian@mehnle.net>
Re: Efficient Way to Merge Two Large Tables Joshua Rubin <jrubin@esoft.com>
Re: Efficient Way to Merge Two Large Tables Joshua Rubin <jrubin@esoft.com>
Re: Efficient Way to Merge Two Large Tables "Daniel Verite" <daniel@manitou-mail.org>
Re: Efficient Way to Merge Two Large Tables Ben Chobot <bench@silentmedia.com>
Re: Efficient Way to Merge Two Large Tables Joshua Rubin <jrubin@esoft.com>
	Joshua Rubin wrote:

> I need to figure out why this is slow, and if there is any faster way.

Have you considered INSERTing into a third table that would replace both
source tables when it's over? The target table would initially have no index.

Best regards,
-- 
Daniel
PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org
В списке pgsql-general по дате отправления
От: Sean E. Connolly
Дата:
От: Thomas Kellerer
Дата:
FAQ