Andres Freund (Tech)

@AndresFreundTec

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

Vrijeme pridruživanja: kolovoz 2017.

Medijski sadržaj

  1. 2. velj

    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:

    Prikaži ovu nit
  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:

    Prikaži ovu nit
  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.

    Prikaži ovu nit
  5. Bad life choices:

    Prikaži ovu nit
  6. Optimized version (emit aliasing info, force llvm's hand to coalesce byte-wide stores, encode knowledge when deforming starts afresh) now yields:

    Prikaži ovu nit
  7. Maybe I'm weird, but I still get a rise of seeing tuple deforming optimized to this:

    Prikaži ovu nit
  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 ;))

Čini se da učitavanje traje već neko vrijeme.

Twitter je možda preopterećen ili ima kratkotrajnih poteškoća u radu. Pokušajte ponovno ili potražite dodatne informacije u odjeljku Status Twittera.

    Možda bi vam se svidjelo i ovo:

    ·