| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Jim C(dot) Nasby" <jim(at)nasby(dot)net> |
| Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org, Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] Incrementally Updated Backup |
| Date: | 2006-09-20 21:50:48 |
| Message-ID: | 19737.1158789048@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
"Jim C. Nasby" <jim(at)nasby(dot)net> writes:
> My thought is that in many envoronments it would take much beefier
> hardware to support N postmasters running simultaneously than to cycle
> through them periodically bringing the backups up-to-date.
How you figure that? The cycling approach will require more total I/O
due to extra page re-reads ... particularly if it's built on a patch
like this one that abandons work-in-progress at arbitrary points.
A postmaster running WAL replay does not require all that much in the
way of CPU resources. It is going to need I/O comparable to the gross
I/O load of its master, but cycling isn't going to reduce that at all.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-09-20 22:07:29 | Re: [HACKERS] Incrementally Updated Backup |
| Previous Message | Jim C. Nasby | 2006-09-20 21:44:32 | Re: [HACKERS] Incrementally Updated Backup |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-09-20 22:07:29 | Re: [HACKERS] Incrementally Updated Backup |
| Previous Message | Jim C. Nasby | 2006-09-20 21:44:32 | Re: [HACKERS] Incrementally Updated Backup |