3 ms·
Do you mount a volume in the container to store the data or does PostgreSQL write in the container file system?
by speedgoose 3y ago
Do you mount a volume in the container to store the data or does PostgreSQL write in the container file system?
- osigurdson 3y agoI tried two things: 1) podman volume create (and use that volume in the container) 2) do not specify a volume (allowing postgres to write to its own data directory i the container) The results for both approaches are the same. I didn't try creating an external bind mount to a Windows directory as I read many articles concluding that this is slow.
- gwnywg 3y agoOut of curiosity, is Windows your requirement? I wonder how would benchmark on Linux look compared to what you measured on Windows. Remembering all my experience with WSL I'd guess there are things going on in the background that are hard to debug
- osigurdson 3y agoIn production, postgres is virtually always run on Linux. I suspect pgbench results would be considerably better. This is more of a development use case. Still, the performance degradation even in development is quite impactful.