credativ U.S. | DBA/DBRE | Remote U.S.| Full-Time credativ U.S. provides Open Source support and consulting services focused on the WebOps space. At this time we are primarily looking for DBA/DBRE folks, although we do…
It is worth noting that while extremely rare, it is possible that we could encounter an issue during packaging which might necessitate a change, in which case that commit stamp might not be the same. Unless folks are…
There was an additional talk on this subject from Bryan Cantrill at Surge 2015 which should be available in video form soon. Interested parties might want to follow @OmniTI on twitter to catch the announcement.
"Both are equally valid", except that the former (a data type) is more equally valid than the latter (pseudo-version), since the SQL Standard defines it that way.
Facebook also uses Postgres and one of the nosql variants (hadoop iirc). Also MySpace uses Aster Data's stuff, which is all built on top of Postgres. shrug
According to the current ruby driver author, the latest driver should support back to Postgres 7.4. Any older version of postgres is unsupported by the postgres project itself, but if you really need something that old,…
Yikes... didn't mean to make you so defensive! Let me retort and clarify (hopefully with understanding that this is not meant as criticism) :-) First, I know people doing rails+slony; I think the most common way is by…
Wow! For less than $5000 and a days work, you could have hired any number of postgres consultants to setup PITR warm standby for you (or Slony if you really thought you needed the read slaves). Instead, you migrated…
Just to clarify, hot standby wasn't backed out, because the changes were never "in". There was a working patch set against the 8.4 tree (which you could still get today) for hot standby, and the testing/review of that…
Anyone who thinks you can scale writes by adding more masters is plain ignorant on the subject. The only way to scale writes is with better hardware or federation of application/data. The first of those is easy, the…
Yes, but the other way around (Oracle's implementation of SQL lines up closer to Postgres). Also, Postgres has a procedural language based off Oracle's PL/SQL language called plpgsql, so if you have experience in one,…
credativ U.S. | DBA/DBRE | Remote U.S.| Full-Time credativ U.S. provides Open Source support and consulting services focused on the WebOps space. At this time we are primarily looking for DBA/DBRE folks, although we do…
It is worth noting that while extremely rare, it is possible that we could encounter an issue during packaging which might necessitate a change, in which case that commit stamp might not be the same. Unless folks are…
There was an additional talk on this subject from Bryan Cantrill at Surge 2015 which should be available in video form soon. Interested parties might want to follow @OmniTI on twitter to catch the announcement.
"Both are equally valid", except that the former (a data type) is more equally valid than the latter (pseudo-version), since the SQL Standard defines it that way.
Facebook also uses Postgres and one of the nosql variants (hadoop iirc). Also MySpace uses Aster Data's stuff, which is all built on top of Postgres. shrug
According to the current ruby driver author, the latest driver should support back to Postgres 7.4. Any older version of postgres is unsupported by the postgres project itself, but if you really need something that old,…
Yikes... didn't mean to make you so defensive! Let me retort and clarify (hopefully with understanding that this is not meant as criticism) :-) First, I know people doing rails+slony; I think the most common way is by…
Wow! For less than $5000 and a days work, you could have hired any number of postgres consultants to setup PITR warm standby for you (or Slony if you really thought you needed the read slaves). Instead, you migrated…
Just to clarify, hot standby wasn't backed out, because the changes were never "in". There was a working patch set against the 8.4 tree (which you could still get today) for hot standby, and the testing/review of that…
Anyone who thinks you can scale writes by adding more masters is plain ignorant on the subject. The only way to scale writes is with better hardware or federation of application/data. The first of those is easy, the…
Yes, but the other way around (Oracle's implementation of SQL lines up closer to Postgres). Also, Postgres has a procedural language based off Oracle's PL/SQL language called plpgsql, so if you have experience in one,…