Andres Freund (Tech)

@AndresFreundTec

Postgres Developer, politics nerd, recently moved to US from Germany. Account about tech related things. For politics:

Joined August 2017

Media

  1. The effect can have on my laptop's power usage is just insane. Having some JS heavy website open more than triples power usage.

  2. Note that for other workloads, with fewer random writes (e.g. increasing shared buffers to contain the whole working set, making small sequential writes more important by using logged tables in an OLTP setup) and more synchronous writes that's not true:

    Show this thread
  3. Bufferbloat, rotational disk + BBU style. In case you still you magnetic disks to back a database taking writes, it can be worthwhile to disable "intelligent" controllers that do their own caching/readahead:

    Show this thread
  4. If your r/w workload is bigger than shared_buffers, seriously consider enabling backend_flush_after. Both throughput *and* jitter are considerably better with it enabled.

    Show this thread
  5. Bad life choices:

    Show this thread
  6. Optimized version (emit aliasing info, force llvm's hand to coalesce byte-wide stores, encode knowledge when deforming starts afresh) now yields:

    Show this thread
  7. Maybe I'm weird, but I still get a rise of seeing tuple deforming optimized to this:

    Show this thread
  8. Hm. Wonder how this 737 (N77296) got these odd patterns of "peeled" off paint. Looks like it's mostly the upper half.

  9. Whoa, git diff --color-moved[=dimmed_zebra] is a nice feature. In the picture below the gray "removed" lines are just moved to a different file, whereas the red "removed" lines are removed during the copy. Shot doesn't show, but changed lines would show up blue.

  10. Even in the 90s programs were stubborn.

  11. Sometimes developing on a Laptop is quite annoying (thanks ;))

Loading seems to be taking a while.

Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.

    You may also like

    ·