Processing very large TEXT columns (300MB+) using C/libpq

From: Cory Nemelka <cnemelka(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Processing very large TEXT columns (300MB+) using C/libpq
Date: 2017-10-19 21:03:31
Message-ID: CAMe5Gn1OMeOutXDLzGOHHO28r8ZYy5URdsuTxP2R14oTMeZ8pw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have getting very poor performance using libpq to process very large TEXT
columns (300MB+). I suspect it is IO related but can't be sure.

Anyone had experience with same issue that can help me resolve?

--cnemelka

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Aldo Sarmiento 2017-10-19 23:20:11 Re: Processing very large TEXT columns (300MB+) using C/libpq
Previous Message Payal Singh 2017-10-19 17:49:54 Re: WAL segement issues on both master and slave server