Re: vacuum full

From: "Henrik Steffen" <steffen(at)city-map(dot)de>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: vacuum full
Date: 2002-11-21 18:20:16
Message-ID: 021e01c2918a$a435d160$7100a8c0@STEINKAMP
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

sorry, didn't notice your message posted to pgsql-general...

but is there any method to see the size in bytes a particular index
for a particular table takes?

--

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.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Stephan Szabo 2002-11-21 18:34:14 Re: stange optimizer results
Previous Message Peter T. Brown 2002-11-21 18:18:53 stange optimizer results