New ideas

Moving distfiles to a new filesystem & deleting unused distfiles

FreshPorts pulls down a lot of distfiles (the file distributed by the software author which contains the software). Much more than your average user. Every distfile for every commit is fetched. Let’s look at my private FreshPorts development instance: [13:18 dvl-ingress01 dvl /jails/freshports/usr/ports] % du -ch -d 0 distfiles 125G distfiles 125G total That’s 125GB.

Moving distfiles to a new filesystem & deleting unused distfiles Read More »

Using triggers to update a table with calculated values

This was originally written in September 2018, but never published (for unknown reasons). I found it in the drafts section of the website today. In this post, you will see me change approach and not use a secondary table in one instance, but use multiple secondary tables in another. In one case, you will also

Using triggers to update a table with calculated values Read More »

Scroll to Top