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

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

pgsql-admin by date

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

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