Re: Re: Hot Standby query cancellation and Streaming Replication integration
Bruce Momjian <bruce@momjian.us>
From: Bruce Momjian <bruce@momjian.us>
To: Fujii Masao <masao.fujii@gmail.com>
Cc: Josh Berkus <josh@agliodbs.com>, Greg Smith <greg@2ndquadrant.com>, Joachim Wieland <joe@mcknight.de>, Greg Stark <gsstark@mit.edu>, Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-03-11T01:39:37Z
Lists: pgsql-hackers
Fujii Masao wrote: > On Wed, Mar 10, 2010 at 3:29 PM, Josh Berkus <josh@agliodbs.com> wrote: > > I've been playing with vacuum_defer_cleanup_age in reference to the > > query cancel problem. ?It really seems to me that this is the way > > forward in terms of dealing with query cancel for normal operation > > rather than wal_standby_delay, or maybe in combination with it. > > Why isn't vacuum_defer_cleanup_age listed on postgresql.conf.sample? > Though I also tried to test the effect of it, I was unable to find it > in the conf file. I asked about that last week and for some reason Simon didn't want it added and Greg Smith was going to get this corrected. Greg? -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do