Re: PostgreSQL Dump rate is too slow
От | Eduardo Morras |
---|---|
Тема | Re: PostgreSQL Dump rate is too slow |
Дата | |
Msg-id | 20150114212058.de1c87d91a851db0bce1f1fa@yahoo.es обсуждение исходный текст |
Ответ на | PostgreSQL Dump rate is too slow (girish R G peetle <giri.anamika0@gmail.com>) |
Ответы |
Re: PostgreSQL Dump rate is too slow
|
Список | pgsql-admin |
On Thu, 8 Jan 2015 11:05:54 +0530 girish R G peetle <giri.anamika0@gmail.com> wrote: > Hi all, > We have a customer who has 1TB database on a production server. They > are trying dump based backup of this large database. Following dump > command is being used. > Dump rate is around 12 GB/hr, which will take lot of time for the > backup to complete. This is affecting their production server. > Is there is a way to increase dump data rate ? > > pg_dump -U <User> -Fc -b --port=<Port> '<Db-Name>' > Do not use pg_dump compression, pipe output to xz % pg_dump -U <User> -Fc -b --port=<Port> '<Db-Name>' | xz -3 dump.xz or pipe xz output to other program. When I looked for the same problem in 8.3-8.4 versions, the bottleneck was in accessing TOAST tables, it's content was decompressed,dumped and recompressed again, don't know if it has changed in current versions. > > PostgreSQL version : 9.2.4 > Platform : Linux > > Thanks > Girish --- --- Eduardo Morras <emorrasg@yahoo.es>
В списке pgsql-admin по дате отправления: