Re: REINDEX DATABASE - Mailing list pgsql-sql

From Achilleus Mantzios
Subject Re: REINDEX DATABASE
Date
Msg-id Pine.LNX.4.44.0508301447460.31870-100000@matrix.gatewaynet.com
Whole thread Raw
In response to Re: REINDEX DATABASE  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
List 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 by date:

Previous
From: "Anthony Molinaro"
Date:
Subject: Re: Time differences between rows, not columns?
Next
From:
Date:
Subject: Re: Time differences between rows, not columns?