Re:Setting up PostgreSQL for running integration tests
by williamdclt on Friday April 19, 2024 @10:57AM
(#40087641)
DELETE is faster on a small amount of data.
But yea, DELETEing is faster than creating a DB from template (depends on how much you have to delete, of course). However, templates allow parallelism by giving its test its own database. I ended up doing a mix of both: create a DB if there's not one available, or reuse one if available, always tearing down data.
Re:Setting up PostgreSQL for running integration tests
by eddd-ddde on Friday April 19, 2024 @11:58AM
(#40088437)
TRUNCATE is faster than DELETE. You could have 100 dbs, each test first acquires one, runs, truncates, releases. No need to create more dbs on the fly.
But yea, DELETEing is faster than creating a DB from template (depends on how much you have to delete, of course). However, templates allow parallelism by giving its test its own database. I ended up doing a mix of both: create a DB if there's not one available, or reuse one if available, always tearing down data.