| From: | Hans-Juergen Schoenig <postgres(at)cybertec(dot)at> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: Endless recovery |
| Date: | 2008-02-11 10:50:00 |
| Message-ID: | 1D1D7200-4C5C-46DA-A517-70CEB623208A@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
>
> I'm sorry to hear about this problem.
No worries - nothing lost ...
>
> Not sure we need a LOG message to warn people about the possible
> length
> of recovery time. The chances of a recovery taking that much time seem
> very low for normal Postgres, even with checkpoint parameters set at
> their maximum values.
It should be quite low - this is what we expected.
>
> I note that the configuration section does not mention the likely
> increase in recovery time that will result from setting those
> parameters
> higher. That needs a patch. ISTM a serious omission that should be
> treated as a bug and backpatched.
>
I have that feeling too - it could very well be some Gist issue in
here but given what we have seen in the debugger this was not too
obvious.
At first glance it rather felt like a full check of the entire index.
best regards,
hans
--
Cybertec Schönig & Schönig GmbH
PostgreSQL Solutions and Support
Gröhrmühlgasse 26, 2700 Wiener Neustadt
Tel: +43/1/205 10 35 / 340
www.postgresql.at, www.cybertec.at
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2008-02-11 11:09:42 | Re: Endless recovery |
| Previous Message | Heikki Linnakangas | 2008-02-11 10:16:30 | Re: Endless recovery |