Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: ALTER INDEX set fillfactor
- From: Simon Riggs <simon(at)2ndquadrant(dot)com>
- To: Dave Page <dpage(at)postgresql(dot)org>
- Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
- Subject: Re: ALTER INDEX set fillfactor
- Date: Sat, 06 Oct 2007 08:33:30 +0100
- Message-id: <1191656010(dot)4223(dot)461(dot)camel(at)ebony(dot)site>
On Fri, 2007-10-05 at 21:24 +0100, Dave Page wrote: > Simon Riggs wrote: > > It would be even better if there was an option to do that CONCURRENTLY, > > i.e. add the new index and then drop the old one afterwards. (It's > > unfortunate that there isn't a REINDEX concurrently, but there isn't > > yet). > > Funny - I suggested that to Greg just the other day... Sorry, I meant in the absence of REINDEX concurrently, we can issue: CREATE INDEX CONCURRENTLY newindex DROP INDEX oldindex on each index on the table in turn, which does the same thing. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com
- References:
- ALTER INDEX set fillfactor
- From: Simon Riggs
- Re: ALTER INDEX set fillfactor
- From: Dave Page
- ALTER INDEX set fillfactor
- Prev by Date: Re: ALTER INDEX set fillfactor
- Next by Date: Re: ALTER INDEX set fillfactor
- Previous by thread: Re: ALTER INDEX set fillfactor
- Next by thread: SVN Commit by hiroshi: r6711 - in trunk/pgadmin3: . pgadmin/dlg
- Indexes: