Remix.run Logo
glenjamin 6 hours ago

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 5 hours ago | parent | next [-]

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.

4 hours ago | parent [-]
[deleted]
allan_s 5 hours ago | parent | prev [-]

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 5 hours ago | parent [-]

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.