# Imports rewrite everything or run twice

Prompts to start with when a PostgreSQL database shows this problem.

- [Stop rewriting data that hasn't changed](https://atlasscope.dev/prompts/stop-rewriting-data-that-hasnt-changed): Upserts and updates run at high volume, imports are costly, or vacuum and write-ahead log churn look high.
- [Can we rerun everything without damaging the data?](https://atlasscope.dev/prompts/can-we-rerun-everything-without-damaging-the-data): Imports get retried, schedulers overlap, files are replayed, or runs fail halfway.
- [Is our ingestion process more complicated than necessary?](https://atlasscope.dev/prompts/is-our-ingestion-process-more-complicated-than-necessary): The import pipeline is long, slow to correct, or does the same work at several stages.

Source: https://atlasscope.dev/fix/imports-rewrite-everything-or-run-twice