From: Francisco Reyes <lists@stringsutils.com>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: John Smith <sodgodofall@gmail.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Backup/Restore of single table in multi TB database
Date: Fri, 18 Jul 2008 20:25:50 -0400
Message-ID: <4881348E.3050002@stringsutils.com> (raw)
In-Reply-To: <1210195724.4268.231.camel@ebony.site>
References: <b88f0d670805071302h469141e0ke29413edddb444e0@mail.gmail.com>
<1210195724.4268.231.camel@ebony.site>
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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: lists@stringsutils.com, simon@2ndquadrant.com, sodgodofall@gmail.com, pgsql-general@postgresql.org
Subject: Re: Backup/Restore of single table in multi TB database
In-Reply-To: <4881348E.3050002@stringsutils.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox