Optimize for insertions?

Поиск

Список

Период

Сортировка

От	Gurupartap Davis
Тема	Optimize for insertions?
Дата	26 ноября 2001 г. 16:33:38
Msg-id	004901c176bf$b03ccbd0$0f00a8c0@marlows обсуждение
Ответы	Re: Optimize for insertions?
Список	pgsql-general

Дерево обсуждения

Hi,

I'm trying to migrate a mysql database to postgresql. I've got the tables all set up, but inserting the data from the mysql dumps is taking forever. I've got about 200 million rows in the big table (growing by about 1.5 million per day), but at the 100 inserts/second I'm getting, this will take over 3 weeks. MySQL on the same machine averages about 1100-1200 inserts/second (no, I'm not running them both at the same time ;-)

Any thoughts on how to tweak the postmaster for quick inserts? I've got fsync turned off, but that's about all I've tried so far.

I'm running postgresql 7.1.3 on Linux (Redhat 7.2 with ext3) with a 700MHz processor, 256MB RAM, and an 80GB IDE HD

Thanks

-partap

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Optimize for insertions?