parameter "vacuum_defer_cleanup_age" - Mailing list pgsql-general

From Tulio
Subject parameter "vacuum_defer_cleanup_age"
Date
Msg-id 4F26E78F.9000502@informidia.com.br
Whole thread Raw
Responses Re: parameter "vacuum_defer_cleanup_age"  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
Re: parameter "vacuum_defer_cleanup_age"  (Marti Raudsepp <marti@juffo.org>)
List pgsql-general
Hi,

    I have 2 servers, working with Hot-Standby and Streaming
    Replication...
    and when we executed some query much large returns a message..
    "canceling statement due to statement
      timeout"
      I want know, how can I calculate the better value to
      "vacuum_defer_cleanup_age" in my case?

      Tell me if you recommend changes in other parameter.

      Thanks

    --
      <meta content="text/html; charset=ISO-8859-1"
        http-equiv="content-type">



      <table style="text-align: left; width: 100%;" border="0"
        cellpadding="2" cellspacing="2">


            <img style="width: 139px; height:
                75px;" alt=""
                src="cid:part1.03010107.08090502@informidia.com.br">
            <span
                  style="font-weight: bold;">Túlio Gustavo dos Santos
                Adm. Téc. em Banco de Dados - TI
                Informídia Pesquisas Esportivas Ltda.
                Tel./Fax.: 55 11 3673 5566
                Email: tulio@informidia.com.br
                twitter: <a
                  href="mailto:www.twitter.com/informidia.com.br">@informidia
                Web: www.informidia.com.br




      <span style="font-size:8.0pt;font-family:Tahoma;
        color:green">Antes de imprimir lembre-se de sua responsabilidade
        e comprometimento com o Meio Ambiente

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: pg_dump -s dumps data?!
Next
From: Scott Frankel
Date:
Subject: restart server on Lion