mattashii

10 ms·

91.
by mattashii 3y ago
Did you mean pgconf.dev in May (which has the unconference), or pgconf.eu in October (which doesn't have an unconference, but the CfP will open sometime in the - hopefully near - future)?
92.
I wrote a new JIT compiler for PostgreSQL(pinaraf.info)
290 points by mattashii 3y ago|35 comments
93.
by mattashii 3y ago
> on ~1 million C programs, compared to [...] 2 trillion tokens, which is a few orders of magnitude more data. Is that comparable like that? This would assume that the average C program of the set is orders (plural) of magnitude less tha
94.
by mattashii 3y ago
That is exactly why I asked: I can't think of a definition that would be both intuitive and that would not rule out reasonable and valid sales strategies for some forms of art.
95.
by mattashii 3y ago
> For that matter, suspend copyright for works that aren’t purchasable. When do you start (or stop) counting something as "purchasable"? Does it mean I can copy the tapes of movies the day before their first screenings, but not
96.
The Frame-by-Frame(qntm.org)
2 points by mattashii 3y ago|0 comments
97.
by mattashii 3y ago
Most "news articles" on the company website over the past year were joint projects from spinoff technologies and corporate rewards, with the most exciting things being them raising 40 million last year. In the meantime, I've
98.
by mattashii 3y ago
Even if you swap RFID identities during transit, the location of each container on the ship doesn't change much during any voyage, so this wouldn't materially change things: the tracker just has to update the ID references with th
99.
by mattashii 3y ago
> The primary visual distinction of the new terminal is that each command is now presented in a separate block Yeah, I'd better like it if they didn't do that. This adds even more visual clutter. > A new, convenient command
100.
by mattashii 3y ago
> A hypothetical megastructure Dyson's sphere would not radiate heat Could you elaborate why not? All current technology I know of has an efficiency of <100%, with waste energy being lost as heat (which in space would be radiated
101.
by mattashii 3y ago
If they (or you) use a cap that's opaque to UV but transparent to the visible spectrum, then there won't be any issues with this.
102.
by mattashii 3y ago
> If the JSON[B] is {amount: 12.09} then you have no guarantee that someone picking it up outside of postgres uses float conversion which could lead to 12.0899999. With BSON, amount is a decimal128 and stays that way, fromBytes() and toB
103.
by mattashii 3y ago
Many modern earth imaging satellites use something called "synthetic aperture radar" where the movement of the satellite is used to increase the aperture for the radar larger than the satellite's own dimensions. Could a simil
104.
by mattashii 3y ago
> It doesn't provide "decimal [...] types", which OP identified as part of the draw to BSON. This part is misinformation, as json[b] works perfectly fine with decimals (well, Numeric, which is an arbitrary precision decima
105.
by mattashii 3y ago
> They're just not worth the cost in infrastructure and lack of efficiency compared to BEVs. Don't BEVs weigh more than hydrogen cars, given the same model and range? That would give at least some incentive to use hydrogen over
106.
by mattashii 3y ago
I'm also concerned about these (tested!) errors: > https://github.com/lanterndata/lantern/blob/040f24253e5a2651... > Operator <-> can only be used inside of an index Isn't the use of the
107.
by mattashii 3y ago
How does performance scale (vs pgvector) when you have an index and start loading data in parallel? Or how does this scale vs the to-be-released pgvector 0.5.2?
108.
by mattashii 3y ago
> 1) Three dimensions, not two. Therefore distance is not the square root of (...) but the cube root of (...). No, it is still a square root. The term under the root is correct, but distance in N dimensions (assuming euclidian space) is
109.
by mattashii 3y ago
The title could use some changes in wording, but "In contrast to data usually stored on the best hard drives and the best SSDs of today..." was clearly referring to the data retention time of those media, and that is indeed often
110.
by mattashii 3y ago
I'll note that that's not at all equivalent to v3's 'connect with psql'. v3 popped open a terminal with psql for the user in a new window (thus giving an equivalent experience to 'normal' use of psql, with
111.
by mattashii 3y ago
I haven't used v4 because last time I wanted to use an UI for managing the DB: - It didn't have 'connect with psql' that v3 did - It added significant overhead and connections to the DB server - It didn't have prope
112.
by mattashii 3y ago
What? Aren't AMD, ARM, and Intel advancing the state of the art of CPUs because they have open platforms, and have no monopoly or gatekeeper position on what software can run on their platform? I can't see why you would be unabl
113.
by mattashii 3y ago
TIL: MySQL has (finally!) changed their release cadence to include an LTS/bugfixes branch. Before, you could accept the current bugs, or expect new ones introduced with the new features in the latest release that includes other bugfixe
114.
MySQL Innovation and Long-Term Support (LTS) Versions(blogs.oracle.com)
3 points by mattashii 3y ago|1 comments
115.
by mattashii 3y ago
I wonder how this compares to e.g. Citus with some triggers and RLS on top. As this does regional accesses of shared and modifiable data, does Nile implement or guarantee snapshot consistency for cross-shard queries? Citus doesn't have
116.
by mattashii 3y ago
Rust borrows must not exceed the lifetime associated with the borrow. By default that indeed means the borrow/reference cannot be moved into a context that outlives the function's execution, so it indeed can't be moved into a
117.
by mattashii 3y ago
> Any computational method that relies on a function that converts m bits (an image) to n bits (a fingerprint) where m > n will always be vulnerable to such an attack. The "vulnerable" depends on your definition: SHA-2 and S
118.
by mattashii 3y ago
Assuming you mean replication (as defined in https://www.postgresql.org/docs/current/warm-standby.html#ST... or https://www.postgresql.org/docs/current/logical-replication.... ), then Pos
119.
by mattashii 3y ago
Open sourcing the changes doesn't mean contributing back to PostgreSQL: Someone has to put in effort to push changes into upstream PostgreSQL, and if it's not Yugabyte, then IMO they're not contributing back.
120.
by mattashii 3y ago
r*-trees work doesn't work well when the number of dimensions stored in the index is much higher than the logarithm of the number of indexed entries, and this is a prevailing property of divide-and-conquer spatial index types when the

More ›