Re: CREATE INDEX ... ONLINE

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Greg Stark <gsstark(at)mit(dot)edu>, pgsql-patches(at)postgresql(dot)org
Subject: Re: CREATE INDEX ... ONLINE
Date: 2006-08-17 11:47:15
Message-ID: 873bbvy470.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches


Greg Stark <gsstark(at)mit(dot)edu> writes:
>
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
>
> > Greg Stark <gsstark(at)mit(dot)edu> writes:
> > > Updated patch. Fixed a few minor things, added documentation and regression
> > > tests. Unfortunately I can't test the regression tests because I get a
> > > segmentation fault earlier in the same file due to a GIN index build. So I
> > > haven't updated the "expected" output.
> >
> > What's the status of this patch --- have you done anything more with it
> > since the 13-Jul submission?
>
> I haven't done anything. I was mostly waiting until I got some feedback about
> the code quality. I figured if there were parts that had to be reworked or
> fixed up I would prefer to do that first before worrying about perfecting
> details which is all that I believe remain.

Just remembered one open question I had. I'm not clear what to do with the
index statistics. It may be that the current code is basically the right thing
-- it leaves the statistics as they are after phase 1, ie after the regular
index build before we go through looking for newly added tuples.

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-08-17 12:23:48 Re: pgstattuple extension for indexes
Previous Message Greg Stark 2006-08-17 10:34:26 Re: An Idea for planner hints

Browse pgsql-patches by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-08-17 12:23:48 Re: pgstattuple extension for indexes
Previous Message Jie Zhang 2006-08-17 07:36:01 Re: [PATCHES] WIP: bitmap indexes