| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Bill Moran <wmoran(at)collaborativefusion(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Online index builds (was: [ANNOUNCE] PostgreSQL 8.2 |
| Date: | 2006-12-05 21:13:42 |
| Message-ID: | 1165353222.31648.54.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-announce pgsql-general pgsql-www |
On Tue, 2006-12-05 at 16:06 -0500, Bill Moran wrote:
> In response to Josh Berkus <josh(at)postgresql(dot)org>:
>
> > -- Online index builds
>
> I'm particularly curious about this feature. Does this mean that
> PostgreSQL 8.2 can perform a REINDEX without blocking the relevant
> table from writes?
I don't know about reindex, but it is possible to drop and create the
index.
Sincerely,
Joshua D. Drake
>
> If so, the 8.2 docs are a bit out of date:
> http://www.postgresql.org/docs/8.2/static/sql-reindex.html
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Moran | 2006-12-05 21:29:42 | Re: Online index builds (was: [ANNOUNCE] PostgreSQL 8.2 |
| Previous Message | Alvaro Herrera | 2006-12-05 21:12:06 | Re: Online index builds (was: [ANNOUNCE] PostgreSQL 8.2 Now Available) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Staubo | 2006-12-05 21:15:39 | Re: Anything I can do to speed up this query? |
| Previous Message | Alvaro Herrera | 2006-12-05 21:12:06 | Re: Online index builds (was: [ANNOUNCE] PostgreSQL 8.2 Now Available) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Moran | 2006-12-05 21:29:42 | Re: Online index builds (was: [ANNOUNCE] PostgreSQL 8.2 |
| Previous Message | Alvaro Herrera | 2006-12-05 21:12:06 | Re: Online index builds (was: [ANNOUNCE] PostgreSQL 8.2 Now Available) |