Glyn Astill <glynast...@yahoo.co.uk> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
