Re: [HACKERS] Re: vacuum timings

On Fri, 21 Jan 2000, Bruce Momjian wrote:

> OK, new timings with -F enabled:
> 
>     index    no index
>     519    same    load    
>     247    "    first vacuum
>     40    "    other vacuums
>     
>     1222    X    index creation
>     90    X    first vacuum
>     80    X    other vacuums
>     
>     <1    90    delete one row
>     121    38    vacuum after delete 1 row
>     
>     346    344    delete all rows
>     440    44    first vacuum
>     20    <1    other vacuums(index is still same size)
> 
> Conclusions:
> 
>     o  indexes never get smaller

this one, I thought, was a known?  if I remember right, Vadim changed it
so that space was reused, but index never shrunk in size ... no?

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org