re: replication... the version of eRServer that PgSQL, Inc released OSS earlier this fall is Java based, actually... only perl is for the admin scripts, and the OSS community is in the process, I believe, of getting rid of that also...
Jan Wieck is also just in the process of re-writing replication based on the experiences of eRServer, again, as an OSS project, and it can be viewed at:
The benchmarks being disputed here were *NOT* sponsored by PostgreSQL... they were sponsored by Great Bridge, which is a third-party support company whose first Open Source project they have taken on to support is PostgreSQL...
That would be like Progress running benchmarks on MySQL being the same as being sponsored by MySQL, which is not the case...
Actually, I must disagree here...at work, we use Oracle and *everything* is on the OSs file system, based on recommendations from Oracle themselves...this place doesn't do anything without checking wtih the vendor half a dozen times first, and even then they have to ask once more:(
Actually, we don't do 'row level locks'...we went one further and went straight to using MVCC. See the following URL for an explanation, since its not something easy to sum up in a few words:
Just curious, but what version of PostgreSQL are you basing this on? When I st arted using PostgreSQL 4 years ago (approx), I wouldn't have used it for a missi on critical apps myself, but now...database corruption bug reports aren't someth ing I see...
See eRServer on GBorg
Jan Wieck is also just in the process of re-writing replication based on the experiences of eRServer, again, as an OSS project, and it can be viewed at:
Slony-1 on GBorg
The benchmarks being disputed here were *NOT* sponsored by PostgreSQL ... they were sponsored by Great Bridge, which is a third-party support company whose first Open Source project they have taken on to support is PostgreSQL ...
That would be like Progress running benchmarks on MySQL being the same as being sponsored by MySQL, which is not the case ...
Actually, I must disagree here...at work, we use Oracle and *everything* is on the OSs file system, based on recommendations from Oracle themselves...this place doesn't do anything without checking wtih the vendor half a dozen times first, and even then they have to ask once more :(
http://www.postgresql.org/docs/postgres/mvcc.htm
Just curious, but what version of PostgreSQL are you basing this on? When I st arted using PostgreSQL 4 years ago (approx), I wouldn't have used it for a missi on critical apps myself, but now...database corruption bug reports aren't someth ing I see...