Re: Backup/Restore of single table in multi TB database - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Backup/Restore of single table in multi TB database
Date
Msg-id 4881348E.3050002@stringsutils.com
Whole thread Raw
In response to Re: Backup/Restore of single table in multi TB database  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Backup/Restore of single table in multi TB database
List pgsql-general
Simon Riggs wrote:
> Have a look at pg_snapclone. It's specifically designed to significantly
> improve dump times for very large objects.
>
> http://pgfoundry.org/projects/snapclone/
>
Also, in case the original poster is not aware, by default pg_dump
allows to backup single tables.
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?

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: tsearch dictionary list?
Next
From: Bret Schuhmacher
Date:
Subject: using regexp_matches and array manipulation