Re: Database size growing over time and leads to performance impact

Поиск
Список
Период
Сортировка
От Scott Carey
Тема Re: Database size growing over time and leads to performance impact
Дата
Msg-id 1C31A98A-7789-452F-844C-D52ECD27D788@richrelevance.com
обсуждение исходный текст
Ответ на Re: Database size growing over time and leads to performance impact  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Дерево обсуждения 
On Apr 1, 2010, at 1:42 PM, Tom Lane wrote:

> Scott Carey <scott@richrelevance.com> writes:
>> Still off topic:
>
>> Will CLUSTER/VF respect FILLFACTOR in 9.0?
>
>> As far as I can tell in 8.4, it does not.
>
> Works for me, in both branches.
>

I stand corrected.  I must have done something wrong in my test.  On a different system I tried FILLFACTOR=45 and
FILLFACTOR=90and the resulting size was nearly a factor of two different. 

>             regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Database size growing over time and leads to performance impact
Следующее
От: Christiaan Willemsen
Дата:
Сообщение: Using high speed swap to improve performance?