Glyn Astill <glynastill@xxxxxxxxxxx> wrote: > Does anyone know of any tricks to replace primary key indexes > without using reindex? Or any other method that will not lock the > table for an extended amount of time on 8.4? > > I've got a bloated primary key index on a table and I'd like to > try and clean it up without downtime. You could create a unique index concurrently on the same columns. Perhaps that would help with performance problems from the bloat until you had a window to drop the redundant index and reindex the table? -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
