Simon Riggs wrote:
Also, in case the original poster is not aware, by default pg_dump allows to backup single tables.Have a look at pg_snapclone. It's specifically designed to significantly improve dump times for very large objects. http://pgfoundry.org/projects/snapclone/
Just add -t <table name>.Does pg_snapclone works mostly on large rows or will it also be faster than pg_dump for narrow tables?
