| From: | Dimitri Fontaine <dfontaine(at)hi-media(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Subject: | Re: Admission Control Policy |
| Date: | 2009-12-28 21:53:02 |
| Message-ID: | F721A6D2-C3FA-422D-8734-070A3AF079ED@hi-media.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Le 28 déc. 2009 à 22:46, Andres Freund a écrit :
>> <mad proposal time>
>> I'd be in favor of considering how to get pgbouncer into -core, and now
>> that we have Hot Standby maybe implement a mode in which as soon as a
>> "real" XID is needed, or maybe upon receiving start transaction read write
>> command, the connection is handled transparently to the master. </>
> Thats not as easy as it sounds - the master may not have all data needed by
> the snapshot on the slave anymore.
I suppose that if it was easy some patch would already be around for next commit fest? :)
Seriously, your point is why I'd be tempted to only consider getting to the master at transaction starting time. That is before any snapshot is taken.
Regards,
--
dim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2009-12-28 21:59:21 | Re: Admission Control Policy |
| Previous Message | Andres Freund | 2009-12-28 21:46:41 | Re: Admission Control Policy |