Re: parameter "vacuum_defer_cleanup_age"

From: Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
To: Tulio <tulio(at)informidia(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: parameter "vacuum_defer_cleanup_age"
Date: 2012-01-31 00:12:40
Message-ID: CAFcNs+ok8ZJEatZRWd6Mo6m0JufDpPmsNa6ZBExicm8go9-jEg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

2012/1/30 Tulio <tulio(at)informidia(dot)com(dot)br>

> 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" ?

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-01-31 01:41:17 Re: [GENERAL] Why extract( ... from timestamp ) is not immutable?
Previous Message Scott Marlowe 2012-01-30 22:45:27 Re: Why Hard-Coded Version 9.1 In Names?