in-transaction insert performance in 7.5devel

Список
Период
Сортировка
От Merlin Moncure
Тема in-transaction insert performance in 7.5devel
Дата
Msg-id 6EE64EF3AB31D5448D0007DD34EEB34101AE59@Herge.rcsinc.local
обсуждение исходный текст
Ответы Re: in-transaction insert performance in 7.5devel  (Rod Taylor)
Re: in-transaction insert performance in 7.5devel  (Tom Lane)
Список pgsql-performance
Дерево обсуждения
in-transaction insert performance in 7.5devel  ("Merlin Moncure", )
 Re: in-transaction insert performance in 7.5devel  (Rod Taylor, )
 Re: in-transaction insert performance in 7.5devel  ("Merlin Moncure", )
  Re: in-transaction insert performance in 7.5devel  (Rod Taylor, )
 Re: in-transaction insert performance in 7.5devel  (Tom Lane, )
 Re: in-transaction insert performance in 7.5devel  ("Merlin Moncure", )
  Re: in-transaction insert performance in 7.5devel  (Tom Lane, )
 Re: in-transaction insert performance in 7.5devel  ("Merlin Moncure", )
I am batch inserting insert statements into a database with fsync = on.
My single disk system is on a 10k drive...even though I am inside a
transaction there is at least 1 file sync per row insert.

Is this normal?  On my hardware, which is pretty quick, I am limited to
about 50 inserts/sec.  If I operate outside of a transaction, the number
is closer to 30.  With fsync off, I can hit over 1000.

IIRC in previous versions insert performance was a lot faster when in
transaction, is that the case?

Merlin

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: in-transaction insert performance in 7.5devel
Следующее
От: Vitaly Belman
Дата:
Сообщение: Additional select fields in a GROUP BY