Re: Row Visibility and Table Access Methods

2018-12-14 Thread Jonah H. Harris
On Fri, Dec 14, 2018 at 12:28 AM Pavel Stehule wrote: > > > čt 13. 12. 2018 v 10:23 odesílatel Simon Riggs > napsal: > >> Thoughts? >> > > looks great > Agreed. This sounds well-thought-out and rather simple to implement. -- Jonah H. Harris

Re: Row Visibility and Table Access Methods

2018-12-13 Thread Pavel Stehule
čt 13. 12. 2018 v 10:23 odesílatel Simon Riggs napsal: > Currently, tables provide MVCC access semantics as the only option. > > A more complete list of desirable semantics in applications are > > * MVCC - provide latest consistent view > * Historical - keep all old row versions so that queries c

Row Visibility and Table Access Methods

2018-12-13 Thread Simon Riggs
Currently, tables provide MVCC access semantics as the only option. A more complete list of desirable semantics in applications are * MVCC - provide latest consistent view * Historical - keep all old row versions so that queries can access data as it used to be * TTL=Duration - keep committed row