Обсуждение: parameter "vacuum_defer_cleanup_age"

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

<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

On Mon, Jan 30, 2012 at 20:55, Tulio <tulio@informidia.com.br> wrote:
> 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?

This error doesn't happen due to recovery conflict, so
vacuum_defer_cleanup_age doesn't make any difference. The error
happens because the statement_timeout setting is configured somewhere
(maybe per-database or per-user settings). Set it to 0 to disable the
statement timeout.

Regards,
Marti

Hi Marti,

    The parameter statement_timeout isn't configured..
    I'm using the value default.. 0..

    And this is happening when I'm doing large querys on the slave..

    thanks,
    Tulio

    Em 01/02/2012 12:33, Marti Raudsepp escreveu:
    <blockquote
cite="mid:CABRT9RC=XoYRx=eHtkAYSxAGesU_hKGAORCzZV1WbqkGfOmYWw@mail.gmail.com"
      type="cite">
      On Mon, Jan 30, 2012 at 20:55, Tulio <tulio@informidia.com.br> wrote:


        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?



This error doesn't happen due to recovery conflict, so
vacuum_defer_cleanup_age doesn't make any difference. The error
happens because the statement_timeout setting is configured somewhere
(maybe per-database or per-user settings). Set it to 0 to disable the
statement timeout.

Regards,
Marti