4 ms·
Well, that's a nice intro to DRAM, but I'm unclear as to its relevance to database/file structure [whether on hard disk or RAM].
by CalmQuiet 18y ago
Well, that's a nice intro to DRAM, but I'm unclear as to its relevance to database/file structure [whether on hard disk or RAM].
- davidw 18y agoYou could always get the source code... But the speed mostly comes from being in memory (or at least that's my guess). That pretty much trumps any structure: http://news.ycombinator.com/item?id=468611 http://news.ycombinator.com/item?id=468611 Also, it's fairly slow for some operations: http://news.ycombinator.com/submitted?id=davidw http://news.ycombinator.com/submitted?id=davidw Seems to be quite slow, for instance.
- CalmQuiet 18y agoHmmm... I hadn't realized submissions retrieval would be so slow, since my 17 submissions show almost instantaneously; your hundreds do take a while. Something about the indexing for submissions doesn't work that fast, even though all in memory?
- davidw 18y agoMaybe, since the submissions stretch back over a longer time (I submit less than I comment), they're hitting the disk, and consequently slow?
- CalmQuiet 18y agoThat seems likely. But I thought I saw a thread where pg seemed to say it was all in RAM ? [Though in a fairly recent post, I seem to recall he was musing about upgrading from a 32 to a 64 system - and working with more than 4GB RAM. Can all HN comments & indexes be happening in 4GB RAM? ]