Re: queries are fast after dump->restore but slow again after some days dispite vacuum

Поиск
Список
Период
Сортировка
От Laszlo Nagy
Тема Re: queries are fast after dump->restore but slow again after some days dispite vacuum
Дата
Msg-id 5009045F.8020502@shopzeus.com
обсуждение исходный текст
Ответ на Re: queries are fast after dump->restore but slow again after some days dispite vacuum  (mandavi <mandavi@web.de>)
Список pgsql-performance
>> Are you running a lot of full table updates?
> If you mean updates which are applied on every or almost every row of
> the table - yes, it happens with two rather small tables of max. 10
> 000 rows. But they are both not touched by the query with this big
> performance difference.
I'm not an expert, but would it help to change fillfactor to about 45%?
I'm just guessing that full table updates with fillfactor=45% could
store the rows on the same page. Maybe I'm wrong.

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

Предыдущее
От: "mark"
Дата:
Сообщение: Deferred constraints performance impact ?
Следующее
От: Ioannis Anagnostopoulos
Дата:
Сообщение: A very long running query....