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
обсуждение исходный текст
Ответ на Re: Efficient Way to Merge Two Large Tables  (Joshua Rubin <jrubin@esoft.com>)
Список pgsql-general
    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"
Дата:
Сообщение: NASA needs Postgres - Nagios help
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: pg_dump and --inserts / --column-inserts