Re: parameter "vacuum_defer_cleanup_age" - Mailing list pgsql-general

From Tulio
Subject Re: parameter "vacuum_defer_cleanup_age"
Date
Msg-id 4F28046C.1080809@informidia.com.br
Whole thread Raw
In response to Re: parameter "vacuum_defer_cleanup_age"  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
List pgsql-general
<meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">


    Fabrizio,

    I'm using the value default..
    The situation was when I executed some query large in the server
    Slave, because I'm trying do balancement of charge.

    Somebody could help me to solve this problem?

    System: CentOS
    Postgresql version:  9.1

    Em 30/01/2012 22:12, Fabrízio de Royes Mello escreveu:
    <blockquote
cite="mid:CAFcNs+ok8ZJEatZRWd6Mo6m0JufDpPmsNa6ZBExicm8go9-jEg@mail.gmail.com"
      type="cite">
      2012/1/30 Tulio <<a
            moz-do-not-send="true" href="mailto:tulio@informidia.com.br">tulio@informidia.com.br>
        <blockquote class="gmail_quote" style="margin:0 0 0
          .8ex;border-left:1px #ccc solid;padding-left:1ex">
           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.






      Which the value of the parameter "statement_timeout" ?<br
        clear="all">


      --
      Fabrízio de Royes Mello
      Consultoria/Coaching PostgreSQL
        >> Blog sobre TI: <a moz-do-not-send="true"
          href="http://fabriziomello.blogspot.com" target="_blank">http://fabriziomello.blogspot.com
        >> Perfil Linkedin: <a moz-do-not-send="true"
            href="http://br.linkedin.com/in/fabriziomello"
            target="_blank">http://br.linkedin.com/in/fabriziomello
        >> Twitter: <a moz-do-not-send="true"
            href="http://twitter.com/fabriziomello" target="_blank">http://twitter.com/fabriziomello




    --
      <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.00060209.04040305@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: Merlin Moncure
Date:
Subject: Re: Index on parent/child hierarchy
Next
From: "Nykolyn, Andy (AS)"
Date:
Subject: Intermittent occurrence of ERROR: could not open relation