Re: Backup/Restore of single table in multi TB database

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: Backup/Restore of single table in multi TB database
Дата
Msg-id 4881348E.3050002@stringsutils.com
обсуждение исходный текст
Ответ на Re: Backup/Restore of single table in multi TB database  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: Backup/Restore of single table in multi TB database  (Simon Riggs <simon@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: tsearch dictionary list?
Следующее
От: Bret Schuhmacher
Дата:
Сообщение: using regexp_matches and array manipulation