Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: Allow replacement of bloated primary key indexes without foreign key rebuilds - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Re: Allow replacement of bloated primary key indexes without foreign key rebuilds
Date
Msg-id 22748.1341936168@sss.pgh.pa.us
Whole thread Raw
In response to Re: Re: Allow replacement of bloated primary key indexes without foreign key rebuilds  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Tree view 
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Excerpts from Tom Lane's message of mar jul 10 10:44:03 -0400 2012:
>> What we really want is REINDEX CONCURRENTLY.

> http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.47.9961 ?

Hm ... that paper looks like something we might want to incorporate into
btree's VACUUM processing, but it's not very on-point if someone really
wants to rebuild the index totally.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCH] psql \n shortcut for set search_path =
Next
From: Tom Lane
Date:
Subject: Re: Using pg_upgrade on log-shipping standby servers