Re: slow speeds after 2 million rows inserted

Поиск
Список
Период
Сортировка
От James Neff
Тема Re: slow speeds after 2 million rows inserted
Дата
Msg-id 45955CFB.5080404@tethyshealth.com
обсуждение исходный текст
Ответ на Re: slow speeds after 2 million rows inserted  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-general
Joshua D. Drake wrote:
> You need to vacuum during the inserts :)
>
> Joshua D. Drake
>

I ran the vacuum during the INSERT and it seemed to help a little, but
its still relatively slow compared to the first 2 million records.

Any other ideas?

Thanks,
James

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

Предыдущее
От: Frank Finner
Дата:
Сообщение: Re: slow speeds after 2 million rows inserted
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: slow speeds after 2 million rows inserted