| From: | Marco Nenciarini <marco(dot)nenciarini(at)2ndquadrant(dot)it> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us>, Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | Claudio Freire <klaussfreire(at)gmail(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Gabriele Bartolini <gabriele(dot)bartolini(at)2ndquadrant(dot)it>, desmodemone <desmodemone(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Proposal: Incremental Backup |
| Date: | 2014-08-07 15:55:17 |
| Message-ID: | 53E3A165.6000209@2ndquadrant.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Il 07/08/14 17:29, Bruce Momjian ha scritto:
> I am a little worried that many users will not realize this until they
> try it and are disappointed, e.g. "Why is PG writing to my static data
> so often?" --- then we get beaten up about our hint bits and freezing
> behavior. :-(
>
> I am just trying to set realistic expectations.
>
Our experience is that for big databases (size over about 50GB) the
file-level approach is often enough to halve the size of the backup.
Users which run Postgres as Data Warehouse surely will benefit from it,
so we could present it as a DWH oriented feature.
Regards,
Marco
--
Marco Nenciarini - 2ndQuadrant Italy
PostgreSQL Training, Services and Support
marco(dot)nenciarini(at)2ndQuadrant(dot)it | www.2ndQuadrant.it
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marco Nenciarini | 2014-08-07 16:00:27 | Re: Proposal: Incremental Backup |
| Previous Message | Robert Haas | 2014-08-07 15:42:47 | Re: Reporting the commit LSN at commit time |