4 ms·
Postgres is relatively light weight. We use Postgres heavily in integration tests and it's quite fast. I don't see that SQLite would speed things up significant
by sgt 11y ago
Postgres is relatively light weight. We use Postgres heavily in integration tests and it's quite fast. I don't see that SQLite would speed things up significantly other than causing other potential issues due to it being a different database.
- StavrosK 11y agoYou just made me wonder whether disabling fsync for postgres would make your tests behave non-identically to a database that does fsync, and how much faster they would be. Interesting question...
- spacemanmatt 11y agoI'm pretty sure the behavior would be identical except for durability.
- StavrosK 11y agoI think so too. Okay, fsync, off you go for dev.
- jeltz 11y agoYou can get most of the benefit you would get from disabling fsync by just disabling synchronous_commit. Disabling synchronous_commit means that fsyncs are still doen but we do not wait for them to complete.