On Wed, May 29, 2013 at 8:41 AM, Niels Kristian Schjødt <nielskrist...@autouncle.com> wrote: > Thanks > > Can you think of a way to select all the indexes programmatically from a > table and run CREATE INDEX CONCURRENTLY for each of them, so that I don't > have to hardcode every index name + create statement ?
You can use something like SELECT pg_get_indexdef(indexrelid) FROM pg_index. You will need to filter it not to include system indexes, toast, etc, and then insert the CONCURRENCY part, but it should give you a good startingpoint. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
