Re: REINDEX DATABASE

Поиск
Список
Период
Сортировка
От Achilleus Mantzios
Тема Re: REINDEX DATABASE
Дата
Msg-id Pine.LNX.4.44.0508301447460.31870-100000@matrix.gatewaynet.com
обсуждение исходный текст
Ответ на Re: REINDEX DATABASE  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Список pgsql-sql
O Achilleus Mantzios έγραψε στις Jul 28, 2005 :

> O Chris Browne έγραψε στις Jul 27, 2005 :
> 
> 
> I'll try to postpone the next reindexdb at the end of august,
> and get some numbers then.
> However the big difference in performance as i told was near the 2GB 
> "threshold", and at *that* point (and maybe for different reasons)
> performance gain was remarkable.
> 

Well, today i run reindexdb and i noticed a decrease in database size,
from 2890148K to 2527552K, about
12.54% decrease in size.
However i have not an estimation of the distribution 
of the SQL commands (INSERT,UPDATE,DELETE) over August.
I am running 7.4.6.

> 
> 

-- 
-Achilleus



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

Предыдущее
От: "Anthony Molinaro"
Дата:
Сообщение: Re: Time differences between rows, not columns?
Следующее
От:
Дата:
Сообщение: Re: Time differences between rows, not columns?