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.

Tweetovi

Blokirali ste korisnika/cu @AndresFreundTec

Jeste li sigurni da želite vidjeti te tweetove? Time nećete deblokirati korisnika/cu @AndresFreundTec

  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.

    Poništi
  2. 31. sij

    Slides (somewhat repaired) for my talk Asynchronous IO for PostgreSQL (and probably also Direct IO) are at

    Poništi
  3. 31. sij

    Well, that was a bit dramatic. While walking to give the presentation, my laptop shut down. Refused to boot again with something like "No TPM found". Luckily booted after disabling the TPM in bios. Certainly doesn't make for a relaxed start into presenting. Sorry for that!

    Poništi
  4. 27. sij

    Update: That's been fixed since. Thanks

    Prikaži ovu nit
    Poništi
  5. 26. sij

    Upgraded Kernel. Now my experimental io_uring branch of postgres is broken :( Different backends, inheriting io_urings from the postmaster, aren't allowed to submit events anymore. Only consume. Hm.

    Prikaži ovu nit
    Poništi
  6. 12. sij

    *but not when benchmarking.

    Prikaži ovu nit
    Poništi
  7. 12. sij

    When idle my workstation's power supply regulates down its fan so much it stalls. Which then causes it to go to full speed to "recover". At least I think that's the issue. So to work without undue distraction I now have to trigger load in the background, but not benchmarking.

    Prikaži ovu nit
    Poništi
  8. 7. sij

    Probably should look at one of the profile guided binary layout optimizers (e.g.facebook's bolt) and see how much that helps. But I think we also need to look at why our code density/locality is so shitty that we get such a huge number of faults.

    Poništi
  9. 6. sij

    Oh, and besides being complicated: It currently also breaks perf profiles...

    Prikaži ovu nit
    Poništi
  10. 6. sij

    The magic necessary (linker flags to align the text sufficiently, link to libhugetlbfs, editing elf headers with hugeedit --text, setting up accessible hugetlbfs) seems too big for most, but I wonder if there's a way that could be simplified.

    Prikaži ovu nit
    Poništi
  11. 6. sij

    7.608 M/sec iTLB-loads w/ 50.80% iTLB-load-misses for normal mapping, vs 1.547 M/sec iTLB-loads w/ 48.82% iTLB-load-misses with text mapped as a huge page.

    Prikaži ovu nit
    Poništi
  12. 6. sij

    Interesting. Doing the necessary rituals of sacrifice to get postgres started with the text segment mapped as huge pages yields nearly 10% speedup in a highly concurrent workload.

    Prikaži ovu nit
    Poništi
  13. 6. sij

    New workstation. Finally able to build without typing on an uncomfortably warm keyboard. And without it taking like half a day to build debug + opt builds.

    Poništi
  14. 3. sij

    New laptop without a working ethernet port (only via optional adapter, for thinness) and with a intel wifi card. I could easily work around it (had already ordered a thunderbolt 10gbe ethernet card) - but most people would long have given up at that point.

    Prikaži ovu nit
    Poništi
  15. 3. sij

    Once more I'm concluding that not including non-free firmware on installer images for linux distributions (yes, , looking at you), is extremely self defeating. It's ridiculous to see a harder time installing a nearly entirely free system as a win for software freedom.

    Prikaži ovu nit
    Poništi
  16. Why on earth did think it was a good idea to name two different microarchitectures "10th Generation Intel® Core™ i* Processors"? And then choose a numbering scheme that doesn't make a ton of sense, on top?

    Poništi
  17. I know it's a trivial tool, but I just noticed that iprint has been removed from . While there are better tools for almost all uses, they're not as darned simple :). I used it nearly daily. Thanks for maintaining it as long as you did.

    Poništi
  18. I only wish it allowed negative patterns to move individual directories (e.g. tests) to the end, without having to list everything else.

    Prikaži ovu nit
    Poništi
  19. I've now set that to src/include/* src/common/* src/port/* config/* src/makefiles/* src/template/* src/backend/* src/fe_utils/* src/bin/* src/interfaces/libpq/* src/pl/* contrib/* src/interfaces/* doc/* src/test/* allowing me to see the "most crucial" (for me) things first.

    Prikaži ovu nit
    Poništi
  20. Random useful developer discovery for postgres development: git's diff.orderFile option. Allows to change the order in which different files appear in diffs.

    Prikaži ovu nit
    Poništi

Č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:

    ·