Today, I discovered that Postgres materialized views do _not_ inherit their parent table's indexes. This is why my spatial query is still running after 24hours.. 9000 × 50,000,000 = 450 billion geometry comparisons. Doh!
Today, I discovered that Postgres materialized views do _not_ inherit their parent table's indexes. This is why my spatial query is still running after 24hours.. 9000 × 50,000,000 = 450 billion geometry comparisons. Doh!
“Astonishing #discovery by computer #scientist: how to squeeze space into time”
#KelseyHoustonEdwards PhD / #ChalkTalk / #computation / <https://youtube.com/watch?v=8JuWdXrCmWg>
AI: Cure All Diseases - Eric Schmidt on AI
"Rather than rely on clever computation to make the best of conventional camera hardware, some engineers are instead experimenting with optical components such as new apertures, and animal-inspired sensors, that together can gather high-quality visual data that requires less intensive processing."
My CPU is producing a lot of heat in recent days. Most of the time I'm doing #wakegp experiments to fine tune parameters. And I'm also compiling various versions of #Luanti to find out or fight with regressions and report them upstream.
I'm just glad I invested into buying this CPU plus a decent AIO. I can compile debug enabled Luanti from scratch in just about 5 minutes. Interestingly, compiling a debug enabled wakegp with incremental builds takes at least the same amount or even more.
wakegp is written in Rust, Luanti is written in C++. Luanti is a far larger codebase. But I guess the problem's that many of Luanti deps are shared libraries so I don't have to do the compiling or linking for them.
#Rust #programming #dailyNote #cplusplus #compiling #heavycomputation #computation
TOSID Update:
Added formal paper presentation
https://github.com/ha1tch/TOSID/blob/main/tosid-paper.md
As PDF:
https://github.com/ha1tch/TOSID/blob/main/tosid-paper.pdf
The TOSID (Taxonomic Ontological Semantic IDentification System) is a comprehensive taxonomic framework designed to uniquely identify and classify any conceivable entity across the universe. The system uses a structured alphanumeric code that embeds hierarchical information about an entity's fundamental nature, origin, scope, and specific identity.
Latest working (non-paper) version:
https://github.com/ha1tch/TOSID/blob/main/tosid-01.md
Repo:
https://github.com/ha1tch/TOSID
#foss #semantic #taxonomy #compsci #computation #informationtheory #ontology #tosid
New Project!
The TOSID (Taxonomic Ontological Semantic IDentification System) is a comprehensive taxonomic framework designed to uniquely identify and classify any conceivable entity across the universe. The system uses a structured alphanumeric code that embeds hierarchical information about an entity's fundamental nature, origin, scope, and specific identity.
https://github.com/ha1tch/TOSID/blob/main/tosid-01.md
#foss #semantic #taxonomy #compsci #computation #informationtheory #ontology
X X^t can be faster
https://arxiv.org/abs/2505.09814
#HackerNews #X #X^t #can #be #faster #arxiv2505 #Xmatrix #computation #optimization #speedup
We present a new algorithm RXTX that computes product of matrix by its transpose $XX^{t}$. RXTX uses $5\%$ less multiplications and additions than State-of-the-Art and achieves accelerations even for small sizes of matrix $X$. The algorithm was discovered by combining Machine Learning-based search methods with Combinatorial Optimization.
Why agency and cognition are fundamentally not computational
https://www.frontiersin.org/journals/psychology/articles/10.3389/fpsyg.2024.1362658/full
#HackerNews #agency #cognition #computation #psychology #neuroscience