Re: Updates, deletes and inserts are very slow. What can I do make them bearable?

Поиск
Список
Период
Сортировка
От Tim Uckun
Тема Re: Updates, deletes and inserts are very slow. What can I do make them bearable?
Дата
Msg-id AANLkTimWtMnH4jxORg9+zPvhgp1Dk+DhgpcLYYqhv6aD@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Updates, deletes and inserts are very slow. What can I do make them bearable?  (Tim Uckun <timuckun@gmail.com>)
Список pgsql-general
Дерево обсуждения 
One more follow up.

Did a vacuum full on both tables and a re-index on both tables.

Changed the wal_buffers to 16MB  (increased the kernel param as a
result) as per
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

I also turned off fsync but still no joy.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: a query on stored procedures/functions in pgsql
Следующее
От: Josh Kupershmidt
Дата:
Сообщение: Re: pg_temp implicit search path: functions vs. tables