4 ms·
Can you elaborate?
by KingOfCoders 4y ago
Can you elaborate?
- allan_s 4y agoNot the author, but if you have a write intensive workflow and I/O starts to be your blottleneck , compressing the data application-side allow your database to write less bytes, and thus to handle more load for the same capacity.
- OnlyMortal 4y agoBe aware of the number of iops. That’s a killer.
- rovr138 4y agoLook into ETL vs ELT ETL you grab the data from somewhere, transform it to clean it/format it, then load it (in this case to postgres). ELT, you grab the data, load it as is. Then you use another step to extract what you need or transform it. You keep the original data in case you need it there too.