parameter "vacuum_defer_cleanup_age"

Поиск
Список
Период
Сортировка
От Tulio
Тема parameter "vacuum_defer_cleanup_age"
Дата
Msg-id 4F26E78F.9000502@informidia.com.br
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: pg_dump -s dumps data?!
Следующее
От: Scott Frankel
Дата:
Сообщение: restart server on Lion