Viewing profile — bonesmoses

Postgres 19 is looking to be a solid release. I don't think I've seen this much "new" stuff in a single version since v10 came out.

Awesome! I'll look forward to that. :)

Version 3.6 is definitely after we introduced that functionality. It was, alas, rarely deployed though. Usually clients needed a consultant to put together a configuration for them…

There's an option in the Postgres configuration named "track_commit_timestamp" that does this automatically. It's required to be enabled when using LWW as the conflict resolution m…

I don't recall which customer you may have been, but the standard solution to that specific DDL issue with BDR is to use Stream Triggers to enable row versioning. One of the 2ndQua…

You can't even run pgbench unaltered on CockroachDB, as simple table structures and indexes are fundamentally different there. It is in no way a compatible product, and never has b…

In Postgres, updates contain the entire row, including all column values. Since the Spock extension follows the "Last Write Wins" model by default, one row version will win, while …

I'm not against using UUIDs, but it has to be done in a balanced manner. Normal numeric IDs for all surrogates, and then a UUID as an external lookup attribute. You push that exter…

You might want to consider a different name, as there's already a pgcat project which appears to be a logical replication extension to augment native logical replication. https://g…

Right tool for the right job. Users in Tokyo won't be editing accounts for users in Austrailia. There's often a natural partition there where you can leverage the data locality wit…

LWW / LUW systems are a fine first approximation, but generally do not fulfill the strictest guarantees and desirable outcomes for a database without accounting for a lot of edge c…

I had a very protracted DPDR experience start around when I was 12, and slowly dissipated over the course of a decade. I woke up one morning, and it was like I was slapped out of m…

Just the annoyance of having to itemize a receipt _to that granularity_ would annoy me enough to quit working at a company like that.

That's an excellent point. By opening up this can of worms, MySQL fans essentially get free reign to take shots at Postgres for flaws it still has for one reason or another. Percei…

Cross-column statistics are one of my favorites. The way Postgres 10 handles it is really a _huge_ advancement that addresses a painful edge case that has been around for ages. htt…

So far as the speed is concerned, we ran some tests a while back and it came back as nearly native performance when compared to interacting with a non-partitioned table: https://bl…

Which is, almost ironically, going back to vocational training instead of standard Liberal Arts degrees. I triple-majored in Math, Physics, and Computer Science because I had to be…

As someone who went to that Cornell, I somewhat regret my decision. Sure you can cram in as much information as possible in that month, but long-term memory generally requires peri…

Isn't 30% is more than enough? If 3-4 people apply for a single position and 1-2 of them have a degree, then it's a fairly reasonable decision to ignore the other two. And the rati…

Is it really a "reverence" though? When practically everyone and their dog has one, it's the new minimum.

This is in very specific neighborhoods due to gang activity for the most part. It's hardly an indicator of safety over the city in general.

I'm not entirely certain normalizing hyperbole makes sense here. There's a massive difference between ensuring children are safe and supported, and never letting them do anything w…

That may be the case, but they need to update the documentation to reflect that. This is what it currently says: "Note: All the new features required have been submitted for inclus…

Citus currently has major problems joining non-distributed tables with distributed tables, and it doesn't fully support schemas yet. It's almost there, but not quite.

Very informative. Thanks!