Re: vacuum full

ok, but how can I measure index sizes?

--

Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com Tel. +49 4141 991230
mail: steffen(at)topconcepts(dot)com Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline: +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
Ihr SMS-Gateway: JETZT NEU unter: http://sms.city-map.de
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------

----- Original Message -----
From: "scott.marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: "Henrik Steffen" <steffen(at)city-map(dot)de>
Cc: <pgsql-performance(at)postgresql(dot)org>
Sent: Thursday, November 21, 2002 6:32 PM
Subject: Re: [PERFORM] vacuum full

> On Thu, 21 Nov 2002, Henrik Steffen wrote:
>
> >
> > hello all,
> >
> > how often should "vacuum full" usually be run ?
>
> I recommend nightly. Also, check index size. If they are growing, you
> may want to reindex each night or week as well.
>