Hackers' Pub

Syntax	Description	Examples
`"` keyword `"`	Finds the string within quotes, including spaces. Case-insensitive. (Escape quotes inside with `\"`)	`"Hackers' Pub"`
`from:` handle	Finds content written by the specified user.	`from:hongminhee` `from:hongminhee@hollo.social`
`lang:` ISO 639-1	Finds content written in the specified language.	`lang:en`
`#` tag	Finds content with the specified tag. Case-insensitive.	`#HackersPub`
condition condition	Finds content that satisfies both conditions on either side of the space (logical AND).	`"Hackers' Pub" lang:en`
condition `OR` condition	Finds content that satisfies at least one of the conditions on either side of the OR operator (logical OR).	`#HackersPub OR "Hackers' Pub" lang:en`
`(` condition `)`	Combines the operators within the parentheses first.	`(#HackersPub OR "Hackers' Pub" OR "Hackers Pub") lang:en`

Marcel Menzel @wrmsr@peering.social

11/15/2025, 4:29:40 PM

Public

So I upgraded my PostgreSQL database (around 1.2TB in size) from version 17 to 18 on ZFS on Linux yesterday.

Thanks to OpenZFS' block cloning feature, pg_upgrade can use reflinks, speeding up the process massively.

I wrote about this on the PostgreSQL users mailing list in case this might be interesting to someone, and one of the PG devs answered with additional insights about ZFS reflinks, their syscalls and some additonal tooling tricks with PG on CoW filesystems.

Gotta love OSS!

If you have a fediverse account, you can quote this note from your own instance. Search https://peering.social/users/wrmsr/statuses/115554659892786968 on your instance and quote it. (Note that quoting is not supported in Mastodon.)