Re: SSI and Hot Standby

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <simon(at)2ndQuadrant(dot)com>,<tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <drkp(at)csail(dot)mit(dot)edu>,<pgsql-hackers(at)postgresql(dot)org>
Subject: Re: SSI and Hot Standby
Date: 2011-01-21 00:33:20
Message-ID: 4D387FF0020000250003992A@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:

> I'm pretty concerned about the performance implications, too. In
> particular that sounds like you could get an unbounded amount of
> WAL emitted from a *purely read only* transaction flow.

No. Read only transactions wouldn't create any flow at all. And I
suggested that we might want some kind of throttle on how often we
generate snapshots even from the read write transactions. I'm not
at all clear on how you got to the concerns you have. Is there
something in particular I could clear up for you that isn't already
mentioned in the previous emails?

-Kevin

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2011-01-21 00:35:20 Re: One Role, Two Passwords
Previous Message Simon Riggs 2011-01-21 00:28:25 Re: SSI and Hot Standby