Postgres Pro
Downloads
Home   >   mailing lists

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

From Fabrízio de Royes Mello
Subject Re: parameter "vacuum_defer_cleanup_age"
Date
Msg-id CAFcNs+ok8ZJEatZRWd6Mo6m0JufDpPmsNa6ZBExicm8go9-jEg@mail.gmail.com
Whole thread Raw
In response to parameter "vacuum_defer_cleanup_age"  (Tulio <tulio@informidia.com.br>)
Responses Re: parameter "vacuum_defer_cleanup_age"
List pgsql-general
Tree view

2012/1/30 Tulio <tulio@informidia.com.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

pgsql-general by date:

Previous
From: Scott Frankel
Date:
Subject: restart server on Lion
Next
From: Tom Lane
Date:
Subject: Re: list blocking queries