| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org, Andreas Seltenreich <andreas+pg(at)gate450(dot)dyndns(dot)org> |
| Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, Marko Kreen <markokr(at)gmail(dot)com>, pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: Restartable Recovery |
| Date: | 2006-07-16 14:51:47 |
| Message-ID: | 29986.1153061507@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Andreas Seltenreich <andreas+pg(at)gate450(dot)dyndns(dot)org> writes:
> Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
>> [2. text/x-patch; restartableRecovery.patch]
> Hmm, wouldn't you have to reboot the resource managers at each
> checkpoint? I'm afraid otherwise things like postponed page splits
> could get lost on restart from a later checkpoint.
Ouch. That's a bit nasty. You can't just apply a postponed split at
checkpoint time, because the WAL record could easily be somewhere after
the checkpoint, leading to duplicate insertions. Right offhand I don't
see how to make this work :-(
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2006-07-16 15:48:17 | Re: Online index builds |
| Previous Message | Kris Jurka | 2006-07-16 14:44:00 | Re: Windows buildfarm support, or lack of it |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2006-07-16 15:57:55 | Re: Restartable Recovery |
| Previous Message | David Fetter | 2006-07-16 14:18:50 | Re: Have psql display names and OUT/INOUT in \df output |