Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Stephan SzaboDate: 2002-11-21 18:34:14
Subject: Re: stange optimizer results
Previous:From: Peter T. BrownDate: 2002-11-21 18:18:53
Subject: stange optimizer results

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group