Re: Re: Hot Standby query cancellation and Streaming Replication integration - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Re: Hot Standby query cancellation and Streaming Replication integration
Date
Msg-id 201003022344.o22NiGP13389@momjian.us
Whole thread Raw
In response to Re: Re: Hot Standby query cancellation and Streaming Replication integration  (Greg Smith <greg@2ndquadrant.com>)
Responses Re: Re: Hot Standby query cancellation and Streaming Replication integration
List pgsql-hackers
Greg Smith wrote:
> Bruce Momjian wrote:
> >> Right now you can't choose "master bloat", but you can choose the other
> >> two.  I think that is acceptable for 9.0, assuming the other two don't
> >> have the problems that Tom foresees.
> >>     
> >
> > I was wrong.  You can choose "master bloat" with
> > vacuum_defer_cleanup_age, but only crudely because it is measured in
> > xids and the master defers no matter what queries are running on the
> > slave...
> 
> OK with you finding the situation acceptable, so long as it's an 
> informed decision.  From how you're writing about this, I'm comfortable 

Well, consider that in November we were not even sure SR or HS would be
in 9.0.  We got them both, so if it is a little kudgy in 9.0, that's OK.
We are much farther along than I ever expected.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 PG East:  http://www.enterprisedb.com/community/nav-pg-east-2010.do


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Re: Hot Standby query cancellation and Streaming Replication integration
Next
From: Bruce Momjian
Date:
Subject: Re: Avoiding bad prepared-statement plans.