Re: Insert statements really slow

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Insert statements really slow
Дата
Msg-id dcc563d10711091118s4069d221k5e9fca51ef814c1d@mail.gmail.com
обсуждение исходный текст
Ответ на Insert statements really slow  ("Waller, David" <Waller_D@IMSDM.com>)
Список pgsql-general
On Nov 9, 2007 11:53 AM, Waller, David <Waller_D@imsdm.com> wrote:
>
> In MySQL I go through a file in about 2 minutes and it is taking about 30 in
> PG.  I have removed all but the primary key index and have done a BEGIN and
> COMMIT after turning off AUTOCOMMIT.

How many rows are you wrapping in begin/commit pairs?  Hopefully a
good number, but just wondering.

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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Insert statements really slow
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Optimal time series sampling.