DBMIRROR and INSERT transactions lose time ...

Поиск
Список
Период
Сортировка
От Hervé Piedvache
Тема DBMIRROR and INSERT transactions lose time ...
Дата
Msg-id 200303311046.19717.herve@elma.fr
обсуждение исходный текст
Ответы Re: [Pgreplication-general] DBMIRROR and INSERT transactions lose  (Michael Loftis <mloftis@wgops.com>)
Список pgsql-general
Hi,

Who can give us some help with DBMirror ??

We make some test with DBMirror ... for us it's running perfectly ;o)

Only one big trouble ... inserting data in transaction ...
We try to make one transaction with 320 000 inserts ... if the trigger of
DBMirror is not connected we have 100 inserts done in 0.3 sec, with DBMirror
it start quickly but after 1000 insert we lose and lose many time ... 1
second losed by 3000/4000 insert ... after 9 hours we get 45 sec for 100
insert ... :o(

Any idea ? Update ? Patch ? ...

Thanks per advance for your help ... ! :o)

Regards,
--
Hervé


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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Small file taking up lots of disk space
Следующее
От: "shreedhar"
Дата:
Сообщение: Fw: Query