From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Dinesh Chandra 12108 <Dinesh(dot)Chandra(at)cyient(dot)com> |
Cc: | "Madusudanan(dot)B(dot)N" <b(dot)n(dot)madusudanan(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Backup taking long time !!! |
Date: | 2017-01-20 11:48:56 |
Message-ID: | CAFj8pRAHx-Wt4fyJmF=YH-F2_S=mO2E+=JDx+qnunkDP5_FPGA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi
2017-01-20 12:43 GMT+01:00 Dinesh Chandra 12108 <Dinesh(dot)Chandra(at)cyient(dot)com>:
> Exactly parallel option is there in version 9.3 but I can’t upgrade new
> version due to some concerns.
>
> Could you suggest in 9.1 how may I fix it.
>
1. don't use it - you can use physical full backup with export transaction
segments.
or
2. buy faster IO
Regards
Pavel Stehule
>
> *Regards,*
>
> *Dinesh Chandra*
>
> *|Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida.*
>
> *------------------------------------------------------------------*
>
> Mobile: +91-9953975849 <+91%2099539%2075849> | Ext 1078
> |dinesh(dot)chandra(at)cyient(dot)com
>
> Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India.
>
>
>
> *From:* Madusudanan.B.N [mailto:b(dot)n(dot)madusudanan(at)gmail(dot)com]
> *Sent:* 20 January, 2017 5:04 PM
> *To:* Dinesh Chandra 12108 <Dinesh(dot)Chandra(at)cyient(dot)com>
> *Cc:* pgsql-performance(at)postgresql(dot)org
> *Subject:* Re: [PERFORM] Backup taking long time !!!
>
>
>
> If you can upgrade to a newer version, there is parallel pg dump.
>
>
>
> Documentation - https://www.postgresql.org/docs/current/static/backup-
> dump.html
>
>
>
> Related blog - http://paquier.xyz/postgresql-2/postgres-9-3-
> feature-highlight-parallel-pg_dump/
>
>
>
> Which can give significant speed up depending on your machine's I/O
> capabilities.
>
>
>
>
>
>
>
> On Fri, Jan 20, 2017 at 4:54 PM, Dinesh Chandra 12108 <
> Dinesh(dot)Chandra(at)cyient(dot)com> wrote:
>
> Hi Expert,
>
>
>
> I have a database having size around 1350 GB, created in PostgreSQL-9.1 in
> Linux platform.
>
> I am using pg_dump to take backup which takes around 12 hours to complete.
>
> Could you please suggest me how I can make my backup fast so that it
> complete in less hours?
>
>
>
> Thanks in advance.
>
>
>
> *Regards,*
>
> *Dinesh Chandra*
>
> *|Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida.*
>
> *------------------------------------------------------------------*
>
> Mobile: +91-9953975849 <+91%2099539%2075849> | Ext 1078
> |dinesh(dot)chandra(at)cyient(dot)com
>
> Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India.
>
>
>
>
> ------------------------------
>
>
> DISCLAIMER:
>
> This email message is for the sole use of the intended recipient(s) and
> may contain confidential and privileged information. Any unauthorized
> review, use, disclosure or distribution is prohibited. If you are not the
> intended recipient, please contact the sender by reply email and destroy
> all copies of the original message. Check all attachments for viruses
> before opening them. All views or opinions presented in this e-mail are
> those of the author and may not reflect the opinion of Cyient or those of
> our affiliates.
>
>
>
>
>
> --
>
> Regards,
> Madusudanan.B.N <http://madusudanan.com>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Madusudanan.B.N | 2017-01-20 11:52:40 | Re: Backup taking long time !!! |
Previous Message | Dinesh Chandra 12108 | 2017-01-20 11:43:33 | Re: Backup taking long time !!! |