On Wed, Dec 18, 2013 at 4:24 AM, Campbell, Lance <lance(at)illinois(dot)edu> wrote:
> Below is a Linux script I wrote that will drop and create all of the
> indexes for your database with the “concurrently” parameter.
>
>
>
> #!/bin/sh
>
>
>
> dbhost=localhost
>
> database=somedatabasename
>
> dbschema=/tempfile/dbschema.txt
>
> filtered=/tempfile/dbschema_filtered.txt
>
> sql=/tempfile/rebuild_indexes.sql
>
>
>
> rm "$dbschema"
>
> rm "$filtered"
>
> rm "$sql"
>
>
>
> pg_dump -s -h "$dbhost" "$database" > "$dbschema"
>
>
>
Great script !
i think you can add parallel perform each couple (drop & create index). ^^