dbt-labs / dbt-labs/dbt

[Tech debt] Speed up windows integration tests

Open
#10,696 0 comments 0 reactions 0 assignees View on GitHub
engine:v1 type:tech-debt
Dominant language
Rust
Stars
13.8k
Forks
2.6k
Avg merge
21h 31m
Merged PRs (30d)
56

Description

In order to install postgres 16 as part of https://github.com/dbt-labs/dbt-core/pull/10687, we started installing postgres from scratch on every windows CI run. Some ideas to speed things up:
1. create a separate image for windows that pre-installs postgres16, so we have that prebuilt and ready to go.
2. uninstall existing postgres package, use choco install (which appears to be faster), and then figure out how to start postgres as a (or start postgres up on on our own)
* uninstall guide: https://stackoverflow.com/questions/113542/how-can-i-uninstall-an-application-using-powershell
* starting the service will likely take a good amount of time to figure out
* can take inspiration from https://github.com/ikalnytskyi/action-setup-postgres/blob/master/action.yml, or try to use the action directly (first unsuccessful attempt here: https://github.com/dbt-labs/dbt-core/pull/10689)

_Originally posted by @MichelleArk in https://github.com/dbt-labs/dbt-core/issues/10687#issuecomment-2344148930_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.