ants_a

17 ms·

121.
by ants_a 7y ago
Good news is that the table access method API introduced in version 12 makes it possible to build b-tree based tables as extensions.
122.
by ants_a 7y ago
Configuration parameter `track_io_timing = 'on'` will measure I/O time. And running `EXPLAIN (ANALYZE, BUFFERS)` will output per plan node buffer statistics and I/O time spent. On most modern system IO timing has no meas
123.
by ants_a 7y ago
PostgreSQL wire protocol has a concept extended query which splits out query execution into 3 steps, parse, bind and execute. https://www.postgresql.org/docs/devel/protocol-flow.html#PRO... If you send one parse m
124.
by ants_a 7y ago
For batch insert it makes more sense to parse an insert statement for one row and then send bind-execute messages for each row. That would much more efficient than a huge insert statement with interpolated values. Copy doesn't on confl
125.
by ants_a 7y ago
Bson is just terrible. Just as a taste, arrays are encoded as key-value, where key is the array index converted to a decimal string and then stored as zero terminated string with 4 byte length prefixed to it. It boggles the mind why somebod
126.
by ants_a 7y ago
https://quixdb.github.io/squash-benchmark/ Brotli is better, zstd is faster, lz4 is often good enough and a lot faster.
127.
by ants_a 7y ago
Even open to the air might not be enough. I just had a couple of self described "revolutionary thermal design" [1] bulbs fail after less than a year in a one end open glass fixture. [1] https://energenie.com/item.a
128.
by ants_a 7y ago
The important insight was that dark orange/brown only exists in a context. There has to be something lighter visible for it to be perceived as dark. Whereas pink is a different mix of light than red. You can't make a red light bul
129.
by ants_a 7y ago
Here is a good illustration why looking at a glass of water will not work: https://www.youtube.com/watch?v=V9pvG_ZSnCc
130.
by ants_a 7y ago
Color filters may not fade, but backlighting uses white LEDs that do use phosphors that fade over time, except perhaps the quantum dot variety.
131.
by ants_a 7y ago
Is this supposed to pass as documentation? Looking at that document the first reaction is that I would rather spend a decade implementing my own ERP than go anywhere near that mess.
132.
by ants_a 7y ago
I've detected broken memory chips thanks to BTRFS checksumming finding errors, luckily before it had a chance to corrupt any written data. So if anything, a properly checksummed filesystem makes non-ECC RAM less dangerous.
133.
by ants_a 7y ago
Predicting weather and predicting climate are almost completely different things. It's about predicting where a single state space trajectory of a chaotic system ends up versus predicting bounds and average positions for an ensemble of
134.
by ants_a 7y ago
Not really. One of the major complications is that considering an index uncached might become a self fulfilling prophecy. Not using an index because it isn't cached leads to the index never becoming cached, even if long term it would b
135.
by ants_a 7y ago
You can do that on Linux too: modprobe v4l2loopback gphoto2 --stdout --capture-movie | ffmpeg -i - -vcodec rawvideo -pix_fmt yuv420p -threads 0 -f v4l2 /dev/video0
136.
by ants_a 7y ago
Common architectural pattern in northern Europe is externally insulated masonry buildings that have significant amount of mass inside the thermal envelope. In such buildings there is enough time-delay in temperature changes that the time of
137.
by ants_a 7y ago
That does not work particularly well at northern latitudes where sun goes below the horizon for couple of hours in the summer, if that. And it would create time zones between latitudes even within the same country where the difference chang
138.
by ants_a 7y ago
This is commonly done in graphics and physics processing engines. In that domain it's the array-of-structures vs. structure-of-arrays design choice.
139.
by ants_a 7y ago
There is one implementation of hints available as an extension: https://github.com/ossc-db/pg_hint_plan It's unfortunate that it comes off as if maintainers think planner is good enough, because that is demonstrab
140.
by ants_a 7y ago
Swapping the integrated battery is a 5 minute job, so if you are not planning on hauling around multiple batteries, it's not a major issue. I haven't really used the hot swap capability my T440s has, even though I have multiple. M
141.
by ants_a 7y ago
> Some people say it's nonsense to believe an amateur can apply thermal paste better than the factory, others report a 10 degree C difference. Both can be correct.
142.
by ants_a 7y ago
Synchronous talking has a synchronization overhead. If you do the stand-up in the beginning of the day it forces everyone to arrive at the same time. If you do it in the middle of the day it is an interruption for everybody. It's usual
143.
by ants_a 7y ago
I have measured a planned switchover on a lightly loaded system (100tx/s) at 500ms from commit to commit. On larger systems it might be a couple of seconds. Unplanned failover depends mainly on the chosen timeout. Typical used value is
144.
by ants_a 7y ago
If its treated correctly as a set of SQL language API-s with clear ownership and explicitly defined public/private parts. There is a reason why its often considered an anti-pattern, and it is a general lack of discipline in maintaining
145.
by ants_a 7y ago
Standard power for 4 "burner" stove is 7.2 kW, and can be hooked up on 2 separate phases or on one with a 32A breaker.
146.
by ants_a 8y ago
With MVCC writers don't block readers.
147.
by ants_a 8y ago
Sharding the counters would help, but with MVCC the typical solution is a delta table containing +1 and -1 records that is periodically compacted into the main count. With some cleverness about how to perform the compaction it's possib
148.
by ants_a 8y ago
Every image is a plot... This one just has had a bit more processing gone into it than your average demosaiced and noise reduced vacation photo.
149.
by ants_a 8y ago
I think the described use of timestamp is driven by shortcomings of Pythons datetime library not having proper timezone handling. I don't think an approach where database design is driven by the opinions of one single application is go
150.
by ants_a 8y ago
That is going to be a problem regardless of technology. With an enforced schema you will at least know that all of the existing data matches the schema. Without it you have to hope that you had zero bugs while collecting the terabytes of da

More ›