Re: Large number of tables slow insert

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Large number of tables slow insert
Дата
Msg-id dcc563d10808231818l4ad52e58k6b29ba92d6bc51e4@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Large number of tables slow insert  ("Loic Petit" <tls.wydd@free.fr>)
Ответы Re: Large number of tables slow insert
Список pgsql-performance
On Sat, Aug 23, 2008 at 6:59 PM, Loic Petit <tls.wydd@free.fr> wrote:
> 1 table contains about 5 indexes : timestamp, one for each sensor type - 3,
> and one for packet counting (measures packet dropping)
> (I reckon that this is quite heavy, but a least the timestamp and the values
> are really usefull)

But what's the update rate on these indexes and tables?  I'm wondering
if you're not vacuuming aggresively enough to keep up with bursty
update patterns

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

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