The fixed window counter leaks double at the boundary, which is the famous flaw. It also needs somebody who knows where the boundary is. The token bucket I switched to instead leaked 199 in a single window against ordinary steady traffic. Only the sliding log held the limit in all 4 traffic shapes, at 50 times the memory.
A single insert at the front of the order made the second page start with the last row of the first one. Both queries are correct. Paging by offset also reads 900020 rows to return 20 at the deep end, taking 69.5 ms against 1.5 for the same page fetched by key, and the plan says so out loud.
On a 4 core server I produced a load average of 8.19 with the processor at 99 percent and a load average of 8.10 with the processor doing real work 36 percent of the time and 7 processes stuck on the disk. Same alarm, opposite fix. And after a full minute of 4 pegged cores the 1 minute figure still read 2.67.
I walked the dependency graph of 6 packages as the registry recorded them today. Grunt brings 51 packages written by 32 people. The small blocks pitch is literally true, since 40 of the 67 packages have no dependencies at all, but 56 of those 67 have exactly 1 maintainer and 3 names account for 26 of them.
I read every zone in the database for 2011 and refined each jump to the minute. 336 of the 344 jumps are the familiar hour. The other 8 are 30 minutes, 2 hours, 3 hours and twice 1440 minutes: on 30 December, 9 days from now, 2 zones lose the whole day. And 26 zones will finish the year an hour away from where they started it.
javac keeps the difference between x * 2 and x << 1. Nothing below javac keeps it in a form you can measure. The only multiply left in the compiled loop is one the compiler put there itself.
5 plumbing calls make a commit that git log reads. 11 revisions of one 1703 line file cost 187576 bytes loose against 16490 packed. The delta base turns out to be the newest version of the file.
3 broken links in one chain give the same NullPointerException with an empty message. Option turns all 3 into None. Then the allocation counter says the Some costs nothing and it takes -XX:-DoEscapeAnalysis to find it.
16 bytes against 8 is 40 percent more index. Arrival order adds another 23 percent on top of that, plus 3 times the insert time once the index outgrows shared_buffers.
4 prices in every 100 are exact doubles. Across a million amounts the wrong kopeck only ever turned up on an exact half: 3656 of them at 18 percent, none at 20.
Mojibake is deterministic. 6 letters, 12 bytes and 5 code pages, plus a byte table that tells you which pair of encodings collided.