Re: index keeps on growing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brian McCane <bmccane(at)mccons(dot)net>
Cc: Jean-Christophe ARNU <jc(dot)arnu(at)free(dot)fr>, pgsql-admin(at)postgresql(dot)org
Subject: Re: index keeps on growing
Date: 2002-06-19 13:25:31
Message-ID: 3750.1024493131@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Brian McCane <bmccane(at)mccons(dot)net> writes:
> The perl script will allow you to rebuild your indexes (indices?) without
> having to kick out all of your users. It reclaims all of the "holes" in
> the index files. It does NOT preserve the "primary key" setting for an
> index, because as far as I can tell this doesn't actually make any
> difference, primary keys are just an UNIQUE index.

The primary-key marker does actually make a difference in just one case
(AFAIK): when you create a foreign key reference from another table,
the primary key serves to identify the default columns to reference.
If you drop the marker then subsequent attempts to create referencing
columns will have to explicitly identify the referenced columns.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Paul Warner 2002-06-19 14:08:19 pg_dump and restore problem (7.0.? to 7.2)
Previous Message Brian McCane 2002-06-19 12:30:40 Re: index keeps on growing