Folf
LightNews LightNews
folf.me
Folf
@folf.me
35 followers 44 following 11 posts
uwu
dev @ @uncollap.se
Posts Replies Media Videos
folf.me
You're on bluesky, the delete button is cosmetic pleasantry; everything here is public forever no matter who you are
June 16, 2025 at 1:15 AM
folf.me
ahhh fair, the whole firehose has been over 70M in the last 3/4 days alone xwx
November 21, 2024 at 10:19 PM
folf.me
jazco.dev/2023/05/20/p...
Speeding up Postgres Queries by 200x with Analyze
Postgres uses an internal table called ‘pg_statistic’ to keep track of some metadata on all tables in the DB. Postgres’s Planner uses these statistics when estimating the cost of operations, which, if...
jazco.dev
November 21, 2024 at 10:18 PM
folf.me
oh also if you're storing things like likes you'll have insanely large table sizes which makes analyze run very rarely, check out autovacuum_analyze_threshold/scale_factor
November 21, 2024 at 10:14 PM
folf.me
ALTER TABLE SET STATISTICS is your friend
November 21, 2024 at 10:10 PM
folf.me
i miss when java-deobfuscator was active
September 27, 2024 at 2:15 AM