Setting up PostgreSQL for running integration tests

Re:Setting up PostgreSQL for running integration tests by ritz_labringue on Friday April 19, 2024 @07:45AM (#40085597)

Why can't you just create a pool of databases and truncate all tables after each run ? That should be pretty fast

[ Parent | on HN ]

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.

[ Parent | on HN ]

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.

[ Parent | on HN ]