Optimizing large data loads

Поиск
Список
Период
Сортировка
От John Wells
Тема Optimizing large data loads
Дата
Msg-id 57890.66.192.236.118.1123244718.squirrel@devsea.com
обсуждение исходный текст
Ответы Re: Optimizing large data loads  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
Hi guys,

We have a Java process that uses Hibernate to load approximately 14 GB of
data.  One a dual-proc 2.4 GHZ Xeon with 2048 MB RAM, it's currently
taking over 13 hours to load (PostgreSQL 7.4.8).  We're flushing from
hibernate every 50 records.

I've turned fsync to false in postgresql.conf, and we've turned autocommit
off in our code.  Is there anything else I could try to temporarily speed
up inserts?

Thanks very much for your help.

John


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

Предыдущее
От: David Goodenough
Дата:
Сообщение: Re: Does preparing statements other than selects help performance?
Следующее
От: Stephane Bortzmeyer
Дата:
Сообщение: Re: wanting to use postgres with python - WHAT am I doing wrong?????? AGGGHHHH