Re: PostgreSQL Write Performance

Поиск
Список
Период
Сортировка
От Tim Uckun
Тема Re: PostgreSQL Write Performance
Дата
Msg-id 855e4dcf1001051421t2e391c47kb9381657e0730057@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL Write Performance  ("Dann Corbit" <DCorbit@connx.com>)
Ответы Re: PostgreSQL Write Performance  (Greg Smith <greg@2ndquadrant.com>)
Re: PostgreSQL Write Performance  (Craig Ringer <craig@postnewspapers.com.au>)
Re: PostgreSQL Write Performance  (Stephen Cook <sclists@gmail.com>)
Re: PostgreSQL Write Performance  (Dimitri Fontaine <dfontaine@hi-media.com>)
Список pgsql-general
> You might use the copy command instead of insert, which is far faster.
> If you want the fastest possible inserts, then probably copy is the way
> to go instead of insert.
> Here is copy command via API:
> http://www.postgresql.org/docs/current/static/libpq-copy.html
> Here is copy command via SQL:
> http://www.postgresql.org/docs/8.4/static/sql-copy.html
>

Is there a command like COPY which will insert the data but skip all
triggers and optionally integrity checks.

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

Предыдущее
От: Tim Uckun
Дата:
Сообщение: Re: timestams in the the pg_standby output
Следующее
От: Greg Smith
Дата:
Сообщение: Re: timestams in the the pg_standby output