Re: in-transaction insert performance in 7.5devel

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: in-transaction insert performance in 7.5devel
Дата
Msg-id 1086980100.2539.187.camel@jester
обсуждение исходный текст
Ответ на in-transaction insert performance in 7.5devel  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Список pgsql-performance
On Fri, 2004-06-11 at 14:40, Merlin Moncure wrote:
> 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.

Which filesystem?

PostgreSQL isn't issuing the sync except at commit of a transaction, but
some filesystems do wacky things if you ask them too.



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

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: in-transaction insert performance in 7.5devel
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: in-transaction insert performance in 7.5devel