| From: | Pavel Drankov <titantins(at)gmail(dot)com> |
|---|---|
| To: | Gaurav Lankepallewar <glankepallewar(at)aumtech(dot)com> |
| Cc: | pgsql-in-general(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL Question |
| Date: | 2017-11-02 12:26:19 |
| Message-ID: | CAO5GBXdqUMK5oWMG8nLAni=xga_Zya0M+ymFf3060CDKrdC0mw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-in-general |
Hi,
About restoring database in 15 minutes... I would say - "it depends". It
depends on disk io speed, backup size and disk durability. Increased disk
load can lead to increasing of disk failure ratio. I mean slowing down may
be connected not with PostgreSQL but with end of your disk lifecycle.
Best wishes,
Pavel
On 2 November 2017 at 13:44, Gaurav Lankepallewar <
glankepallewar(at)aumtech(dot)com> wrote:
> Hello team,
>
> I am working on PostgreSQL 9.3 where we have database created and that we
> used to keep as back up server. Our requirement is to drop that database
> and restore after every 15 minutes. But we don't know if it cause anywhere
> on the server or anything slows down after doing this frequently.
>
> Awaiting your reply...
>
> Thanks,
> Gaurav L.
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | chris kim | 2017-11-02 17:39:24 | standby has a wal file issue |
| Previous Message | Gaurav Lankepallewar | 2017-11-02 10:44:55 | PostgreSQL Question |