MeltanoLabs / MeltanoLabs/tap-postgres
Investigate performance issues
@edgarrmondragon is already working on this.
Since Feb 25, 2025.
- Dominant language
- Python
- Stars
- 26
- Forks
- 42
- PR merge metrics
- No merged PRs in 30d
Description
I debugged this ELT (a log file with 13+ GB of content), and there are no traces of redundancy, every record appears only once.
The
target-postgresbatch_processing_time is an average of 20 s to each batch, and it sums to ~6 minutes of totalCOPYoperation time, which is acceptable.The
tap-postgresaverage extraction time interval between records is ~0.001 s, what leads (roughly) to a total of 90 minutes of data reading.
If anyone has ideas, evidence (or even better, a flame graph 😉) as to what's causing this performance problem, they're more than welcome!
Related
- https://github.com/MeltanoLabs/tap-postgres/issues/284
- Maybe https://github.com/MeltanoLabs/tap-postgres/pull/551?
Links
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.