228900+ entries in 0.141s
mircea_popescu: yes but what it uses it for is sorts, select by index may use it if
the index is composite.
mircea_popescu: and work_mem should prolly be larger
than 4mb, but hard
to guess how large without a profile, and
this is a major resource consumption
ticket, so you actually want
to do some maffs.
mircea_popescu: 1) shared_buffers is
to be per spec "25% of available ram" ; but it does diminish returns in
the gb. you probably have it as 128mb, make it 2gb say.
mircea_popescu: incidentally asciilifeform since we're now doing open source db optimization shared_buffers is probably a larger concern. what is it ? defaults
to 125mb but i'd readily see it 1-4gb in your case.
a111: Logged on 2016-12-30 14:32 Framedragger: (do note, 'work_mem' is per user / per request. so may be easier
to DoS.
thought i should mention
this for completeness)
a111: Logged on 2016-12-30 14:30 asciilifeform: i'ma
try it soon.
a111: Logged on 2016-12-30 12:28 davout: was
there a discussion of
the use case where one wishes
to create, and sign
transactions from an arbitrary set of unspent inputs?
a111: Logged on 2016-12-30 09:13 davout: out of curiosity, how long did it
take
trb node operators
to fully sync?
mircea_popescu: if he weren't a
total fucking retard on
top of being a consumate conman, he'd actually have 30k
to buy an isp now.
mircea_popescu: and for
the record :
the dood colluded with sonny vleisides /
the rest of
the 'ndrangheta running "bfl" scam (which, obviously,
the usg hasn't ever prosecuted, in spite of loud violation of, eg, parole
termas, because hey, partners in crime)
to falsely claim
that he received a miner delivery so as
to scam bitbet into misresolving a bet, on which
they had ~500 btc.
mircea_popescu: oh hey, check it out, irc isn't
that important. smart move, barely
tolerated fraudster.
mircea_popescu: oh also, friendly reminder
today's last day of eulora hackathon. closes in ~11 hours.
diana_coman: asciilifeform,
to round off: atm eulora code is basically c99 (even
that rather reluctantly when we moved over
to 64bit)
jurov: i was just paraphrasing, don't remember
the exact word
mod6: when I get a free moment, i'll
throw
the latest eulora on
there. can be my mining box. :]
jurov: For
the uninitiated,
there's already c++17 underway. With folks gearing up
to c++23, when We Will Finally Reach Parity With Haskell(noshit).
mod6: i had obsd on it like for nearly all of '16... but wasn't doing anything with it. so i
threw linux on
there.
mod6: nice! i haven't done any sledding yet. gotta do
that one of
these
times.
diana_coman: how's
that eulora-box coming in 2017 mod6 ? :D
diana_coman: got
to some snow, sledged downhill, even bruised a knee , got back
to peaceful coding now , lol
diana_coman: fwiw I can confirm
that current code compiles perfectly fine on gcc 4.4 in any case
diana_coman: basically crystalspace has its own "boost" implementation yes, leaking as expected and on
top of
that planeshift uses it all over
the place quite without any rhyme or reason, adding further
to
the swamp;
mircea_popescu: that's ok,
the planeshift implementation leaks at pretty much every other rivet
mircea_popescu: (they did decide
to move over
to unity last year,
then
they abandoned
the plan._
diana_coman: and it manages
to have some half million lines of code doing
the job of maximum 100k by
the looks of it
mircea_popescu: the quality of code is uneven in
the usual foss sense ; its main virtue is
that being old, it is mostly not new.
mircea_popescu: asciilifeform planeshift is a mmorpg
that
the many-eyes beast
took 10 years
to make. it uses cs which is a sort of game engine, which is built on cal3d which is a gfx lib.
jurov: planeshift is opensource game, crystalspace is
the engine
diana_coman: planeshift is an open source mess
that was used
to jumpstart eulora basically
mircea_popescu: the server code's not published, and
the client code is mostly legacy.
jurov: it does not use much c++stdlib, but
the crystalspace reimplementation of
diana_coman: asciilifeform, atm we are still slowly, slowly extricating ourselves from
the swamps of ps code
mircea_popescu views with mind's eye diana_coman 's beard growing inches/second in
the minds of alf
mircea_popescu: "was gcc 5.x rms approved or not ?" "dude... who cares. it fails
to build eulora."
mircea_popescu: note
that as
time rains on,
this sort of query becomes less and less interesting
mircea_popescu: sure. i'm not saying it must be standardized. just,
there.
mircea_popescu: asciilifeform hey, i'm not surfe i want it
to work on heathens what.
mircea_popescu: incidentally, i would say deedbot also counts as
tmsr keyserver now.
mircea_popescu: for
that matter
they fail
to change
their own diapers, either, end up having Framedragger write code for
them etc.
mircea_popescu: on
the other hand submitter support is not mandated,
they fail
to produce a significant portion of
the input.
jurov: asciilifeform: journal is not some magic allowing you
to have 100k
transactions.second without possibility of data loss
jurov: just a side note - if using filesystem, for ACID guarantee you'd need
to flush caches,
too
mircea_popescu: Framedragger
think for a second : modulus gets added, it's in cache, other modulus gets added,
they don't get checked against each other because one was in cache, now we have
two unpopped poppables in db.
Framedragger: i suspect
then
that
the inserts/sec slowness is due
to postgres currently making really damn sure
that *all* layers of cache are forced.
this "full forcing of cache for every row" is what makes
things slower; but it's also
the only really-super-reliable approach for
the case at hand (remote box).
mircea_popescu: what you do is not supposed
to be predicated on what you can do at any point in your existence.
Framedragger: mircea_popescu: because you could
tell postgres
to flush rows (forcing all caching layers) every 100 rows, not every 1 row as currently specified
mircea_popescu: the issue is
the magic numbers. you said "100". why did you say "100" and how did you [think you] knew ?
mircea_popescu: well not exactly like
that, but i guess
that may work for a heuristic early on.
mircea_popescu: consider
the simple case of "check values, actuate machinery" in article linked here a few months ago. it is quite fundamentally informative.
mircea_popescu: because it is not computer-possible
to have what you describe without what i describe.
mircea_popescu: Framedragger see here's what graybeard means : i see
that statement, and I KNOW
there's a footnote somewhere you don't know about / bother
to mention which says "except when abendstar in conjunction with fuckyoustar when it's 105th
to 1095th column".