4 ms·

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 co

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 10mo ago
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.
- deleted 10mo ago
  [deleted]
allan_s 10mo ago
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 https://github.com/allan-simon/postgres-eatmydata
- anarazel 10mo ago
  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 10mo ago
    Huh, i always just mounted the data directory as tmpfs/ramdisk. Worked nicely too