Mastodawn

For our own compute we've been averaging daily:
- 1464 core hours (full cores, not SMT)
- 396 of which were windows (visible due to the licensing cost)
- 40GB of artifacts
- doesn't include macos, which I can't track as easily, due to being self hosted runners

So we will likely need something where we can continue to provide compute ourselves, to keep this affordable.

Show thread

AndresFreundTec Apr 9

Any suggestions / experiences where to look next?

AndresFreundTec Apr 9

Postgres until now has been using cirrus-ci for CI. Unfortunately they're shutting down June 1st.

They had been a good fit for us because:
- some free credits so everyone could run some CI on their own
- supported providing own compute for more demanding cases (via GCP and self hosted mac HW)
- jobs ran in one-off VMs
- support for custom images allowed us to pre-install everything, keeping test times manageable
- VMs not containers was good for perf
- CI job definitions could be run locally

AndresFreundTec Apr 7

Somehow the number of cases in which one needs to slap __attribute__((always_inline)) on static inline functions to prevent gcc from creating a non-inline [partial] versions in a TU seems to be steadily increasing.

AndresFreundTec Apr 5

That'd work, but the better fix is to simply not have the lock in the first place :). Which we did a few months ago...

AndresFreundTec Jan 21

Russ Cox Jan 19

“Floating-Point Printing and Parsing Can Be Simple And Fast”

The fastest known floating-point printer and parsing algorithms - fixed-width printing, shortest-width printing, and parsing, all in 400 lines of Go.

https://research.swtch.com/fp
https://research.swtch.com/fp-proof

research!rsc: Floating-Point Printing and Parsing Can Be Simple And Fast (Floating Point Formatting, Part 3)

AndresFreundTec Jan 15

If you work on postgres or work intensively with postgres, you should consider submitting a talk to this year's pgconf.dev - the CFP deadline closes tomorrow! It's by far my favorite conference of the year!

https://2026.pgconf.dev/cfp

Show thread

AndresFreundTec Jan 14

That experience has stopped me from making some terrible UX choices over the years (although I still have committed plenty UI crimes).

AndresFreundTec Jan 14

Got my start into making money with computers helping seniors learn computers. To this day I remember trying and failing to give a short & coherent explanation of when to use single clicks and when double clicks in Windows (must have been 98 and XP), File Explorer and Browsers. And the despair of the seniors not understanding..

Never really could come up with something that was better than "you should intuitively know".

AndresFreundTec Jan 8

Hoped for effect of AI use of new postgres contributors: Faster rampup, higher quality patches.

Real effect: A torrent of pointless patches, which often don't even pass tests. A torrent of AI generated pointless review comments.