[glenjamin]

Does pglite in memory outperform “normal” postgres?

If so then supporting the network protocol so it could be run in CI for non-JS languages could be really cool

[jitl]

Look into libeatmydata LD_PRELOAD. it disables fsync and other durability syscalls, fabulous for ci. Materialize.com uses it for their ci that’s where i learned about it.

[allan_s]

for CI you can already use postgresql with "eat-my-data" library ? I don't know if there's more official image , but in my company we're using https://github.com/allan-simon/postgres-eatmydata

[anarazel]

You can just set fsync=off if you don't want to flush to disk and are ok with corruption in case of a OS/hw level crash.

[ffsm8]

Huh, i always just mounted the data directory as tmpfs/ramdisk. Worked nicely too