Use PdfMerger with file handles (not PdfWriter ) to avoid memory blowouts.
Combine with pandas for instant CSV export. Use PdfMerger with file handles (not PdfWriter )