274 karma · joined June 14, 2020
Yes, the `journal_size_limit` affects the maximum journal/wal file that remains on disk if larger than that — and by the way ensures that these files are not deleted once created.
Your setting it to ~25MiB while the default `wal_autocheckpoint` PRAGMA is set to 1000 pages (with the typical page size of 4KiB that means after ~4MiB the WAL file contents will get moved to the main database file if no other transaction is active) is what confused me. 25MiB seems very specific for a file size to keep in the occasion that the WAL file keeps growing beyond 4MiB. Perhaps you also meant to tinker with the `wal_autocheckpoint` PRAGMA but didn't?
> After serveral retries
A “vertical join” (SQL UNION) is one of the “non-left joins”. How can you transform a “vertical join” to a “left join”?
$ tclsh
% puts $tcl_version
8.6
% expr "9999999999999999.0-9999999999999998.0"
2.0I think what they found is a set of circumstances where the energy of the light “chips off pieces” of water, so the energy needed is much less. A small broken-off “piece” (or cluster of water molecules) has a very large ratio of surface area over volume, so the rest of the evaporation is taken care of by the surrounding environment as-is.
Also in _The Moon Is a Harsh Mistress_ he made the research of what is humour be one of the primary self-assigned directives of Mike (the accidentally created GAI).
IMO a proper pro-tip for `qalc` would need an explanation why one should prefer it over `units`.
Yes, the word “European” (inhabitant of Europe) is rooted on the Greek word Europē, Zeus' mythical mistress (one of many), after whom both the continent and the satellite were named, but is the “-ean” a proper transcription from Greek?
Perhaps “Europaean” could be the better answer to the question we discuss; after all, in English the continent's name is a modernized “Europe” while the satellite stays closer to the intermediate Latin as “Europa”, and since this discussion is in English, I feel that the difference in suffix justifies a different label for the inhabitants of the satellite.
$ units
You have: 100 km per hour / 0.956 sec
You want: gravity
* 2.9629132
/ 0.33750567The is-hyphen-part-of-a-word issue depends on the text control (browser, UI widget library, …) / terminal you use, which is not universal.
In any case, the hyphens/dashes are not required part of the representation, and one can use the “dashless” representation (exactly 32 hex digits) in URLs and in-code without any issues whatsoever, as far as I know; for example, Postgres accepts either “dashful” or “dashless” UUIDs the same.
import itertools as it
def erat3( ):
D = { 9: 3, 25: 5 }
yield 2
yield 3
yield 5
MASK= 1, 0, 1, 1, 0, 1, 1, 0, 1, 0, 0, 1, 1, 0, 0,
MODULOS= frozenset( (1, 7, 11, 13, 17, 19, 23, 29) )
for q in it.compress(
it.islice(it.count(7), 0, None, 2),
it.cycle(MASK)):
p = D.pop(q, None)
if p is None:
D[q*q] = q
yield q
else:
x = q + 2*p
while x in D or (x%30) not in MODULOS:
x += 2*p
D[x] = pI believe in -ce- -ci- -cy- the c is an s, while in -ca- -co- -cu- the c is a k.
Perhaps the etymology is needed to know how to write a k/s sound you've never heard before.