From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Jeff Davis <pgsql(at)j-davis(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Ragnar <gnari(at)hive(dot)is>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Online index builds |
Date: | 2006-12-12 20:33:29 |
Message-ID: | 200612122033.kBCKXT105455@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce pgsql-general pgsql-www |
Jeff Davis wrote:
> On Thu, 2006-12-07 at 18:11 -0500, Tom Lane wrote:
> > Jeff Davis <pgsql(at)j-davis(dot)com> writes:
> > > I think all you need to do what you want is something like:
> > > ALTER TABLE foo DROP CONSTRAINT foo_pkey KEEP INDEX;
> >
> > > Because then you could drop the primary key status on a column without
> > > affecting the column or the index, then use my suggested syntax to
> > > switch the primary key status to a different index like so:
> > > ALTER TABLE foo SET PRIMARY KEY INDEX foo_othercolumn_index;
> >
> > That seems like an awful lot of uglification simply to let the index be
> > marked as "primary key" rather than just "unique".
> >
>
> Agreed. It's just a thought.
>
> The reason it came to my mind is because some applications, like Slony,
> use the primary key by default.
>
> After reading through the archives, it looks like Gregory Stark
> suggested a REINDEX CONCURRENTLY, which would certainly solve the
> awkwardness of maintenance on a primary key. I didn't see much
> objection, maybe it's worth consideration for 8.3?
Added to TODO:
* Allow REINDEX CONCURRENTLY
--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2006-12-12 23:04:46 | Re: Online index builds |
Previous Message | David Fetter | 2006-12-11 08:07:43 | == PostgreSQL Weekly News - December 10 2006 == |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2006-12-12 20:35:06 | Re: Online index builds |
Previous Message | Martijn van Oosterhout | 2006-12-12 20:31:15 | Re: a question on SQL |
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2006-12-12 21:32:50 | gborg & pgfoundry are down |
Previous Message | Gavin M. Roy | 2006-12-12 19:58:49 | Re: Hub.org DNS |