Search Postgresql Archives

Re: warm standby server stops doingcheckpointsafterawhile

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Frank Wittig <fw@xxxxxxxxxxxx>
Subject: Re: warm standby server stops doingcheckpointsafterawhile
From: Teodor Sigaev <teodor@xxxxxxxxx>
Date: Mon, 04 Jun 2007 20:00:50 +0400
Cc: Simon Riggs <simon@xxxxxxxxxxxxxxx>, Postgres General <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <46642E8B.2020504@xxxxxxxxxxxx>
References: <465E9707.4040307@xxxxxxxxxxxx> <29215.1180621420@xxxxxxxxxxxxx> <1180695498.26297.97.camel@xxxxxxxxxxxxxxxx> <46600411.4030207@xxxxxxxxxxxx> <1180698271.26297.117.camel@xxxxxxxxxxxxxxxx> <466017E1.7010602@xxxxxxxxx> <1180705139.26297.136.camel@xxxxxxxxxxxxxxxx> <466031BE.30508@xxxxxxxxxxxx> <46603722.2020208@xxxxxxxxx> <1180715549.26297.196.camel@xxxxxxxxxxxxxxxx> <46604E06.6030107@xxxxxxxxx> <1180717621.26297.217.camel@xxxxxxxxxxxxxxxx> <46606878.5040407@xxxxxxxxx> <46608C44.1040507@xxxxxxxxxxxx> <4663E16A.10706@xxxxxxxxx> <4663FF9A.8080307@xxxxxxxxx> <46642E8B.2020504@xxxxxxxxxxxx>
User-agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.8.1.2) Gecko/20070302 SeaMonkey/1.1.1

After some observation of massive reindexing of some hundred thousand
data sets it seems to me that the slave doesn't skip checkpoints
anymore. (Apart from those skipped because of the CheckpointTimeout thing)
I'll keep an eye on it and report back any news on the issue.


Nice, committed. Thank for your report and testing.
--
Teodor Sigaev                                   E-mail: teodor@xxxxxxxxx
                                                   WWW: http://www.sigaev.ru/

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Re: warm standby server stops doing checkpoints after awhile
  - From: Simon Riggs
- Re: warm standby server stops doing checkpoints after awhile
  - From: Frank Wittig
- Re: warm standby server stops doing checkpoints afterawhile
  - From: Simon Riggs
- Re: warm standby server stops doing checkpoints afterawhile
  - From: Teodor Sigaev
- Re: warm standby server stops doing checkpointsafterawhile
  - From: Simon Riggs
- Re: warm standby server stops doing checkpointsafterawhile
  - From: Frank Wittig
- Re: warm standby server stops doing checkpointsafterawhile
  - From: Teodor Sigaev
- Re: warm standby server stops doingcheckpointsafterawhile
  - From: Simon Riggs
- Re: warm standby server stops doingcheckpointsafterawhile
  - From: Teodor Sigaev
- Re: warm standby server stops doingcheckpointsafterawhile
  - From: Simon Riggs
- Re: warm standby server stops doingcheckpointsafterawhile
  - From: Teodor Sigaev
- Re: warm standby server stops doingcheckpointsafterawhile
  - From: Frank Wittig
- Re: warm standby server stops doingcheckpointsafterawhile
  - From: Teodor Sigaev
- Re: warm standby server stops doingcheckpointsafterawhile
  - From: Teodor Sigaev
- Re: warm standby server stops doingcheckpointsafterawhile
  - From: Frank Wittig

Prev by Date: Re: what to do when pg_cancel_backend() doesnt work?
Next by Date: Re: NULLS and User Input WAS Re: multimaster
Previous by thread: Re: warm standby server stops doingcheckpointsafterawhile
Next by thread: Re: Geographic data sources, queries and questions
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]