I believe large columns get put into a TOAST table. Max page size is 8k. So you'll have lots of pages per row that need to be joined with a size like that: https://www.postgresql.org/docs/9.5/static/storage-toast.htmlAldo SarmientoPresident & CTO8687 Research Dr, Irvine, CA 92618O: (949) 223-0900 - F: (949) 727-4265aldo@bigpurpledot.com | www.bigpurpledot.comOn Thu, Oct 19, 2017 at 2:03 PM, Cory Nemelka <cnemelka@gmail.com> wrote: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
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
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных