27400+ entries in 0.286s
Framedragger: COPY (SELECT pid, client_addr, query_start, query FROM pg_stat_activity WHERE state
<> 'active' ORDER BY client_addr ASC, query_start ASC) TO '/tmp/pg-zombies.txt' WITH CSV DELIMITER ' ';
BingoBoingo:
<shinohai> There are only two seasons in Georgia, slightly chilly and sweltering, humid summer
<< Too cold for citrus, too hot for legumes and cole crops
BingoBoingo:
<mircea_popescu> beans / lentils prolly work better for same purpose.
<< Clover works well too. Assuming shinohai's climate is too hot to get big legumes going
BingoBoingo: * shinohai has only planted radishes and cucumbers, has shitty soil in new locale.
<< Protip: till a plot and sow densly with turnips/radishes. Do not harvest and burn down with glyphosate before first frost. Till vastly improved soil next year.
BingoBoingo: mbined Italian and Jewish police violence."
<< epic.
BingoBoingo:
<mircea_popescu> "celebrating "Palm Sunday", a feast marking their holy tradesman's triumphant return to Jerusalem days before the holy tradesman was martyred by combined Italian and Jewish police violence."
<< epic.
<< Updated, forgot to insert relevant link to earlier qntra
<mircea_popescu> "celebrating "Palm Sunday", a feast marking their holy tradesman's triumphant return to Jerusalem days before the holy tradesman was martyred by co
BingoBoingo:
<asciilifeform> (strangely, even though ti was a megacorp already at the time, their offering was the least memorable)
<< No mystery. They were likely operating from an internal assumption of leadership and thus snore.
mircea_popescu: "celebrating "Palm Sunday", a feast marking their holy tradesman's triumphant return to Jerusalem days before the holy tradesman was martyred by combined Italian and Jewish police violence."
<< epic.
shinohai: I need to dig deeper into that, last attempt at removing the
<> resulted in breaking the whole damned thing because python is a turd.
mircea_popescu: shinohai could it nuke those
<>; it fucks up the logotrons
a111: Logged on 2017-04-08 22:44 asciilifeform:
http://btcbase.org/log/2017-04-08#1640534 << gurl dun like the disciplinary-sanitarium of 'civilized society' and gets diagnosed, unsurprisingly, with вялотекущая шизофрения (tm)(r)(su)
ben_vulpes: so if i have a `std::map
<ktype, std::vector
<vtype>> stuffMap`, is it legal to say `stuffMap[k].push_back(newV)`
trinque: mircea_popescu:
https://www.postgresql.org/docs/current/static/mvcc-intro.html << "Internally, data consistency is maintained by using a multiversion model (Multiversion Concurrency Control, MVCC). This means that each SQL statement sees a snapshot of data (a database version) as it was some time ago, regardless of the current state of the underlying data. This prevents statements from viewing inconsistent
BingoBoingo:
<asciilifeform> mircea_popescu: on contemplation, cars may not be a very good hiding place, they ( esp in usa ) routinely move through chokepoints - toll archs, and these are already equipped with camera and radio receivers
<< Depends on region and car
Framedragger: asciilifeform: hold on. the idea was to separate reads from writes. having a separate box for www which gets updates from phuctor box, and having pg indices on it for quick search is *not* resource-intensive. i can cite examples but basically i'm quite certain that a
<= 16gb memory box would suffice. phuctor box is 256 gigs yes, but it does *so much more*.
shinohai:
http://btcbase.org/log/2017-04-07#1639637 <<< This is what I said to Steemit evangelist R. Hilarski a few days ago when he accused me of just hating on altcoins. "When you lose all your BTC in scams, at least your wife is kinda hot so she can come by trilema and bare her tits for bits."
☝︎ mircea_popescu: trinque> materialized views are nothing more than a named query which stores its results in a table
<< this is a convenience not a speed-up