Re: slow insert query.

Поиск
Список
Период
Сортировка
Искать
От
Richard Huxton
Тема
Re: slow insert query.
Дата
Msg-id
434E7368.8070205@archonet.com
Ответ на
slow insert query. (julien WICQUART)
Список
Дерево обсуждения
slow insert query. julien WICQUART <j.wicquart@newtech.fr>
Re: slow insert query. Richard Huxton <dev@archonet.com>
julien WICQUART wrote:
> 
> But we still have insert that take more that 1s on little table (24000 tupples with 10 rows).
> 
> We've got 633 connexions/mn on our all databases (68 databases with less than 10 rows each) which

How often are you vacuuming?

What does "VACUUM FULL VERBOSE little_table" show for 
removable/non-removable row versions?

-- 
   Richard Huxton
   Archonet Ltd
В списке pgsql-general по дате отправления
От: Bill Bartlett
Дата:
Сообщение: Re: Limitations of PostgreSQL
От: John D. Burger
Дата:
FAQ