log☇︎
215600+ entries in 0.133s
mircea_popescu: it's the funny fate of people at the top of a socialist dictatorship to become very right wing ever as their populace drifts ever more into ustardism.
mircea_popescu: expression famously used by elena ceausescu wrt the general populace. very much in this line of exasperation, they'll chew everything these schmucks.
phf: the wrecker must wreck, for as soon as he stops he becomes the wrecked.
phf: guy who snatched mcclim from g_l, and who otherwise got a somewhat cold treatment from the ccl core before joined the channel the next day with "i guess i should subscribe to mailing list :)"
a111: Logged on 2016-07-20 15:43 phf: so i push back on the guy, rme says "let's change subject", within minutes guy goes "it's late here i gotta go to sleep"
phf: http://btcbase.org/log/2016-07-20#1507131 << in related news, gbyers, the original systems guru of ccl, who responded to every "modernization" attempt with "sure, if you can explain me what's the point" stepped down. within a day, clozure cl was moved to github, with current list of "issues" https://github.com/Clozure/ccl/issues. in case anyone was wondering "what happens when linus steps down" ☝︎☟︎
mircea_popescu: blessfully, there is a large contingent of young women who deeply intuit the whole thing's bullshit ; which is the most that can be said for the place. making the anglophone ideological america VERY much a "city of jerusalem". total jews, these folk.
a111: Logged on 2017-02-07 20:07 deedbot: http://qntra.net/2017/02/socialist-seek-to-replace-socialist-zuckerberg-on-facebook-board-for-insufficient-socialism/ << Qntra - Socialist Seek To Replace Socialist Zuckerberg On Facebook Board For Insufficient Socialism
mircea_popescu: that's the one, only, true and authentic soul of america and naught else. apparent alternatives are always and without exception strictly a) tolerated imports with no substantial intermingling with local idiocy and b) only tolerated because of exterior pressure ; if usian CAN get away with no longer pretending to frenchness, germanity, etc he most definitely will.
mircea_popescu: (not the items depicted, but the vein.)
mircea_popescu: http://trilema.com/2013/how-to-enter-failville/ << this, basically. and it's pre 1800s.
mircea_popescu: if there is to be something substantially murican, to stand with the russki "soul of the peasant", it's a badly typeset secret big town learnin' france doesn't want ms cormack of potato, idaho to know.
mircea_popescu: phf you're exactly right. this current maga-able us economy consisting of "we'll be rich by doing each other's laundry" is not in any sense novel, or invented by the pantsuit mcclinton. in fact, on a frank review of the extant record, the only properly said us-american culture is THIS. in between the quack salesman and the itinerant scammer you find the neoprotestant-innovative firebrand preacher, the systematizing industrial
Framedragger: 112.16.66.170 << running comware, "Comware is an industry-leading provider of network security solutions including products, professional services, and implementation. Our elite team of experts understands complex security issues ..."
deedbot: http://phuctor.nosuchlabs.com/gpgkey/FC3FC7E23DFBDF44C302E52DF687914488B86411CE7929DBBB3035551714DC64 << Recent Phuctorings. - Phuctored: 1135...0847 divides RSA Moduli belonging to '112.16.66.170 (ssh-rsa key from 112.16.66.170 (13-14 June 2016 extraction) for Phuctor import. Ask asciilifeform or framedragger on Freenode, or email fd at mkj dot lt) <ssh...lt>; ' (Unknown CN)
deedbot: http://phuctor.nosuchlabs.com/gpgkey/AD919DC40487AD461B8113F407DECC7E6628E95894E12DDB6ED1197357ADBBCF << Recent Phuctorings. - Phuctored: 1292...5723 divides RSA Moduli belonging to '223.95.173.49 (ssh-rsa key from 223.95.173.49 (13-14 June 2016 extraction) for Phuctor import. Ask asciilifeform or framedragger on Freenode, or email fd at mkj dot lt) <ssh...lt>; ' (Unknown CN)
deedbot: http://phuctor.nosuchlabs.com/gpgkey/FC3FC7E23DFBDF44C302E52DF687914488B86411CE7929DBBB3035551714DC64 << Recent Phuctorings. - Phuctored: 1292...5723 divides RSA Moduli belonging to '112.16.66.170 (ssh-rsa key from 112.16.66.170 (13-14 June 2016 extraction) for Phuctor import. Ask asciilifeform or framedragger on Freenode, or email fd at mkj dot lt) <ssh...lt>; ' (Unknown CN)
deedbot: http://phuctor.nosuchlabs.com/gpgkey/AD919DC40487AD461B8113F407DECC7E6628E95894E12DDB6ED1197357ADBBCF << Recent Phuctorings. - Phuctored: 1063...0329 divides RSA Moduli belonging to '223.95.173.49 (ssh-rsa key from 223.95.173.49 (13-14 June 2016 extraction) for Phuctor import. Ask asciilifeform or framedragger on Freenode, or email fd at mkj dot lt) <ssh...lt>; ' (Unknown CN)
a111: Logged on 2017-02-19 05:18 trinque: https://wiki.postgresql.org/images/4/45/Explaining_EXPLAIN.pdf << sorry for the pdf, but there's "explain"
Framedragger: http://btcbase.org/log/2017-02-19#1615505 << just to note for asciilifeform and given that i didn't see it mentioned in the pdf (could have easily missed it), `EXPLAIN (ANALYZE, BUFFERS) $yoursqlquery` *is* useful. "buffers" will also show how much of postgres cache was hit during query execution, etc. etc.; it's quite nice. ☝︎
jhvh1: danielpbarron: The operation succeeded.
danielpbarron: !~later tell thestringpuller http://wotpaste.cascadianhacker.com/pastes/ICRUI/?raw=true
mats: efforts to retake western half of mosul have begun
phf: i'm 2 weeks away from having to go back to washington, dc. i'm over the hump, and doubling down on hate.
mats: i'll add a trigger warning if there's a next time
phf: the whole vibe of the piece that you linked is that. "here's 10 books i wrote on how to be a leading brain surgeon. i myself am not a brain surgeon of course too hard lol, i just made all the money writing books like that"
mats: i've been away from the valley too long
phf: i wonder if "scott young" used bulletproof coffee every morning, to prep himself up for mit ciriculum study. did he organize his studies using GTD??? what kind of organizer did he use, and where can i buy it? the audience wants to know answers to these vital questions
phf: (i don't know what happened to above sentence. india make me spell good)
phf: i can't vouch for the current edition (with the colourful chronometer on the cover), becaues comments side that it's not just a reprent, but a revised text based on gould's notes.
phf: i picked up https://www.amazon.com/Longitude-Genius-Greatest-Scientific-Problem/dp/080271529X that someone left on the train, it's a popsci history of longitude problem, which in turn pointed me to the gould book, which i found in a local collectors' bookstore
phf: asciilifeform: did you get the new and improved edition? or a pirate pdf of the original? i'm not sure what the warez status of it is, but i can potentially do a proper scan of the first ed
mats: coursera's 'learning how to learn' is also quite good
diana_coman: by this time I rather expect that the underlying truth there is that MIT's "computer science curriculum" simply is watered down
diana_coman: "While there will always be people with unfair advantages" bwahahaa
mats: TIL about the Feynman Technique, via http://calnewport.com/blog/2012/10/26/mastering-linear-algebra-in-10-days-astounding-experiments-in-ultra-learning
BingoBoingo: Much .gov furniture is built that way
asciilifeform: BingoBoingo: iirc ~all electric chairs were built by prisoners (though not usually ones scheduled to sizzle)
asciilifeform: BingoBoingo: there is a surprising tradition of this. i recall reading about a fella in new york who was permitted to build himself an electrically-operated (button in his hand) 'upward jerker' gallows system, and hang on it
BingoBoingo: http://www.jameslafond.com/article.php?id=6657 << "I don’t know why the state doesn’t just put the condemned prisoner under with a general anesthetic and then cut off his head with a sawzall. They are clearly over-thinking the whole process."
asciilifeform: ty trinque , i will make use of this.
trinque: By default costs are in units of “time a sequential 8kb block read takes
trinque: https://wiki.postgresql.org/images/4/45/Explaining_EXPLAIN.pdf << sorry for the pdf, but there's "explain" ☟︎
asciilifeform: trinque: does here exist such a thing as a profiler for pgsql ?
asciilifeform: plan is to rewrite the thing, this spring, with 0 sql.
asciilifeform: mircea_popescu: i do not particularly want to hand off the project, no.
mircea_popescu: seems cheaper than trying to learn sqlish.
mircea_popescu: asciilifeform are you deeply against giving the man access on the machine ?
asciilifeform: established this today.
trinque: ok, you said that you are reading and writing heavily to the same table
trinque: what db is this then
asciilifeform: trinque: understand, the gcd thing takes up ~3 minutes of db time daily. not a significant factor at all.
trinque: write one of those and perform your factoring work upon it
trinque: ok so there are materialized views, yes? stored query the results of which are written to a table
asciilifeform: i have nfi what this sentence means
trinque: to generate your work data, meanwhile inserting into the table the view reads from?
trinque: can you use a materialized view there?
trinque: sure thing is hateful, but you have one, can't use it wrong and lament
trinque: you oughtn't do that
a111: Logged on 2017-02-19 04:32 mod6: (my guess here, is that you're inserting heavily on the same table as you are trying to read from)
trinque: http://btcbase.org/log/2017-02-19#1615456 << this is not a noshit ☝︎
asciilifeform: trinque: how might i go about determining the answer to this ?
trinque: the "concurrent" in acid ought to mean this doesn't happen
trinque: asciilifeform: explain what locks when you're inserting into your keys table
asciilifeform: thestringpuller: at the risk of repeating the words of the cartoon yoga master (who offered the n00b a bed of 1 nail) -- 'gotta start small'
asciilifeform: thestringpuller: if you haven't spent last 20yrs programming, this chore isn't for you, sadly
thestringpuller: asciilifeform: :( learning cliff larger than dwarf fortress. no hints? tips and tricks?
asciilifeform: the ONE THING I ASKED FOR is not in the tunings.
asciilifeform: mod6: i sat for whole day with the tuning. worthless.
asciilifeform: thestringpuller: no, and there is also not a ready guide on self-appendectomy
mod6: there is a lot of configuration/tuning involved. they're picky. :/
thestringpuller: asciilifeform: is there a guide on making this fabled kernel module for fuckgoats?
asciilifeform: when told omfg.
asciilifeform: reading AT MOTHERFUCKING DISK SPEED as it OUGHT TO READ
asciilifeform: we had a thread, where mircea_popescu suggested inserting in massive batches. i will eventually implement this. but i find it offputting that EVEN THEN the IDIOTIC db will prevent me from reading !!!
mod6: and if you're doing (what might be default in pgsql) some sort of full table locking on inserts, then that'd be something to look at.
mod6: (my guess here, is that you're inserting heavily on the same table as you are trying to read from) ☟︎
asciilifeform: i have nfi what that means
asciilifeform: incidentally i measured the thing in between Framedragger parcels
asciilifeform: because the Framedragger data set is pumped in 24/7.
asciilifeform: mod6: they happen constantly
mod6: it would be interesting to see, how often inserts are happening for new key submissions versus, say, something that would facilitate a regular ui page load.
asciilifeform: mod6: well, every single new key submission is from 1 to a dozen no-result queries
mod6: so, UIs are usually victims, ofc. and the bottleneck is in the database. might be worth your time to see what your explain plans look like (are we doing a lot of table scans?), what do your lock counts look like? are we doing lots of long runing queries that return no rows? etc.
mod6: (im much more familiar with mysql's perf schema, not really with psql, but... I find these things very helpful on a regular basis.)
asciilifeform: mod6: just the same old idiocy with 10-40sec per page load.
mod6: asciilifeform: anything catching your eye in the performance statistics?
jhvh1: thestringpuller: The operation succeeded.
thestringpuller: !~later tell danielpbarron: https://dpaste.de/eWi5/raw
asciilifeform: walked the docs. nuffin.
asciilifeform: and again i went 'surely there MUST be a knob to permit-FUCKYOU-UNBLOCKEDALWAYS-READS... i must've missed it' but nope.
mircea_popescu: kinda what they're for.
asciilifeform: (iirc we had a thread where i described how corporate ameritards, if given a problem like phuctor, would happily soak up a few $mil and megawatt of iron) ☟︎☟︎☟︎☟︎☟︎☟︎☟︎☟︎☟︎☟︎☟︎☟︎☟︎
asciilifeform: it may be the most overloaded trabant on planet3
mircea_popescu: "no i'll optimize my truck". eh...
mircea_popescu: in fairness it's a bit like using car for haulage. use train neh.
asciilifeform: sql dbtron is , i suspect, intrinsically unusable for this application
asciilifeform: (despite postgres being permitted to eat massive qty of ram)
asciilifeform: in other softwaresucks, i applied all of the optimizations folx have written to me about re phuctor. still ~same slow.
mircea_popescu: "random number generators" to be taken out and shot.