xzilla

3 ms·

1.
by xzilla 6y ago
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 have some
2.
by xzilla 11y ago
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 comfortable working dir
3.
by xzilla 11y ago
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.
4.
by xzilla 16y ago
"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.
5.
by xzilla 17y ago
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
6.
by xzilla 18y ago
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, you should be able t
7.
by xzilla 18y ago
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 piping the sql to a fi
8.
by xzilla 18y ago
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 your entire architecture
9.
by xzilla 18y ago
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 code ran into enough c
10.
by xzilla 18y ago
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 latter is hard.
11.
by xzilla 18y ago
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, learning the other is