Re: [PERFORM] Dump/Restore performance improvement

2004-09-05 Thread Tom Lane
Adi Alurkar [EMAIL PROTECTED] writes: 1) Add a new config paramter e.g work_maintanence_max_mem this will the max memory postgresql *can* claim if need be. 2) During the dump phase of the DB postgresql estimates the work_maintenance_mem that would be required to create the index in

[PERFORM] Dump/Restore performance improvement

2004-09-04 Thread Adi Alurkar
Greetings, I have observed that in a dump/restore scenario the longest time is spent on index creation for larger tables, I have a suggestion of how the performance could be improved thus reducing the time to recover from a crash. Not sure if this is possible but would definitely be a nice