| From: | Alvaro Herrera <alvherre(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 Now Available) |
| Date: | 2006-12-05 21:12:06 |
| Message-ID: | 20061205211206.GM14220@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-announce pgsql-general pgsql-www |
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?
>
> If so, the 8.2 docs are a bit out of date:
> http://www.postgresql.org/docs/8.2/static/sql-reindex.html
No, it means you can do CREATE INDEX CONCURRENTLY.
http://www.postgresql.org/docs/8.2/static/sql-createindex.html
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2006-12-05 21:13:42 | Re: Online index builds (was: [ANNOUNCE] PostgreSQL 8.2 |
| Previous Message | Bill Moran | 2006-12-05 21:06:27 | Online index builds (was: [ANNOUNCE] PostgreSQL 8.2 Now Available) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2006-12-05 21:13:42 | Re: Online index builds (was: [ANNOUNCE] PostgreSQL 8.2 |
| Previous Message | Scott Marlowe | 2006-12-05 21:09:20 | Re: HELP: Urgent, Vacuum problem |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2006-12-05 21:13:42 | Re: Online index builds (was: [ANNOUNCE] PostgreSQL 8.2 |
| Previous Message | Bill Moran | 2006-12-05 21:06:27 | Online index builds (was: [ANNOUNCE] PostgreSQL 8.2 Now Available) |