"Campbell, Lance" <lance@xxxxxxxxxxxx> writes: > PostgreSQL pg_restore new feature request > I did some testing last week to see how fast I could get pg_restore to reload data. I found some settings that made a significant speed boost. One request I have is the addition of two parameters to pg_restore. > --no-indexes > When this parameter is used during a full restore of a database the indexes would not be applied. > --only-indexes > When this parameter is selected during a full restore of a database only the indexes would be applied. This seems fairly redundant with the existing notion of "dump sections". Have you experimented with "--section=post-data"? regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
