Re: warm standby server stops doingcheckpointsafterawhile - Mailing list pgsql-general

From Teodor Sigaev
Subject Re: warm standby server stops doingcheckpointsafterawhile
Date
Msg-id 46604E06.6030107@sigaev.ru
Whole thread Raw
In response to Re: warm standby server stops doingcheckpointsafterawhile  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: warm standby server stops doingcheckpointsafterawhile  ("Simon Riggs" <simon@2ndquadrant.com>)
List pgsql-general
> I'd suggest we throw an error, as shown in the enclosed patch. Frank,
> can you give that a whirl to provide Teodor with something more to work
> with? Thanks.

I already makes a test suite which reproduce the problem - it leaves incompleted
splits. But I discover one more problem: deadlock on buffer's lock. So, right
now I investigate the problem.

>
> Neither GIST nor B-tree seems to throw an error in corresponding
> locations also, so the potential for not being able to track this is
> high. I'd want to throw errors in those locations also.

Agreed, I'll add more check
--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

pgsql-general by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: warm standby server stops doingcheckpointsafterawhile
Next
From: "Tyler Durden"
Date:
Subject: Seq Scan