Re: Large number of tables slow insert

Поиск
Список
Период
Сортировка
От Loic Petit
Тема Re: Large number of tables slow insert
Дата
Msg-id 1775c5ea0808231747m71c4e75fn9b5c45ed604edfe8@mail.gmail.com
обсуждение исходный текст
Ответ на Large number of tables slow insert  ("Loic Petit" <tls.wydd@free.fr>)
Ответы Re: Large number of tables slow insert  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-performance
I was a bit confused about the read and write sorry ! I understand what you mean...
But do you think that the IO cost (of only one page) needed to handle the index writing is superior than 300ms ? Because each insert in any of these tables is that slow.
NB: between my "small" and my "big" tests the only difference is the number of table (10 and 3000), there is almost the same amount of on-disk data

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

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Large number of tables slow insert
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Large number of tables slow insert