[GENERAL] Commit visibility guarantees

2009-05-18 Thread Marsh Ray
Hello Everyone, I'm looking at an easy real-time application using PostgreSQL. Looking at the pg docs, I see lots of discussion about cases where MVCC may reflect different versions of the data to different connections. For example: http://www.postgresql.org/docs/8.1/static/mvcc.html "while quer

Re: [GENERAL] Commit visibility guarantees

2009-05-18 Thread Marsh Ray
On Mon, May 18, 2009 at 4:53 PM, Ben Chobot wrote: > On Mon, 18 May 2009, Marsh Ray wrote: >> Hello Everyone, >> I'm looking at an easy real-time application using PostgreSQL. > As I understand real-time applications, PostgreSQL is inherintly unsuited > for the task. The

Re: [GENERAL] Commit visibility guarantees

2009-05-18 Thread Marsh Ray
On Mon, May 18, 2009 at 5:24 PM, Sam Mason wrote: > Even then it's not useful to class it as real-time; nothing "bad" > happens if you don't get a response before timeout the user just gets an > error message.  Real-time applies when if you don't get a response the > plane crashes or a heart stops

Re: [GENERAL] Commit visibility guarantees

2009-05-18 Thread Marsh Ray
On Mon, May 18, 2009 at 5:14 PM, Sam Mason wrote: > On Mon, May 18, 2009 at 04:38:36PM -0500, Marsh Ray wrote: >> The central question: So if I successfully commit an update >> transaction on one connection, then instantaneously issue a select on >> another previously-ope

Re: [GENERAL] Commit visibility guarantees

2009-05-18 Thread Marsh Ray
On Mon, May 18, 2009 at 6:20 PM, Tom Lane wrote: > Marsh Ray writes: >> The central question: So if I successfully commit an update >> transaction on one connection, then instantaneously issue a select on >> another previously-opened connection, under what circumstances am

Re: [GENERAL] Humor me: Postgresql vs. MySql (esp. licensing)

2003-10-09 Thread Marsh Ray
Oliver Elphick wrote: But as far as Debian is concerned, paragraph 1 applies: 1. Free use for those who are 100% GPL If your application is licensed under GPL or compatible OSI license approved by MySQL AB, you are free and welcome to ship any GPL software of MySQL AB with your application. By "