| Lists: | pgsql-in-general |
|---|
| From: | Gaurav Lankepallewar <glankepallewar(at)aumtech(dot)com> |
|---|---|
| To: | pgsql-in-general(at)postgresql(dot)org |
| Subject: | PostgreSQL Question |
| Date: | 2017-11-02 10:44:55 |
| Message-ID: | 2c164a6b-6740-93f7-597c-21a926b41a4a@aumtech.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-in-general |
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: | 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 |
| 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.
>
>
>
>