Re: Continual uptime while loading data ... COPY vs INSERTS within a transaction.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Continual uptime while loading data ... COPY vs INSERTS within a transaction.
Дата
Msg-id 4253.1202603234@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Continual uptime while loading data ... COPY vs INSERTS within a transaction.  (Benjamin Arai <me@benjaminarai.com>)
Ответы Re: Continual uptime while loading data ... COPY vs INSERTS within a transaction.
Список pgsql-general
Дерево обсуждения 
Benjamin Arai <me@benjaminarai.com> writes:
> We are thinking of modifying our system to use COPY to replace these
> large INSERT transactions but we are concerned that it will greatly
> impact the user experience (i.e., exclusively lock the table during the
> copy process).  First, does COPY grab an exclusive lock? Second, is
> there a better way to load data?

No, and no.  Use COPY.

            regards, tom lane

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

Предыдущее
От: "Christopher Browne"
Дата:
Сообщение: Re: Continual uptime while loading data ... COPY vs INSERTS within a transaction.
Следующее
От: "Dean Gibson (DB Administrator)"
Дата:
Сообщение: Where is the system-wide psqlrc on RHEL4?