On Mon, Jan 30, 2012 at 20:55, Tulio <tu...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
