Scanning a large binary field

Поиск
Список
Период
Сортировка
Искать
От
Kynn Jones
Тема
Scanning a large binary field
Дата
Msg-id
c2350ba40903151342r8dec52cl2834105e0fb44128@mail.gmail.com
Список
Дерево обсуждения
Scanning a large binary field Kynn Jones <kynnjo@gmail.com>
Re: Scanning a large binary field John R Pierce <pierce@hogranch.com>
Re: Scanning a large binary field Kynn Jones <kynnjo@gmail.com>
Re: Scanning a large binary field John R Pierce <pierce@hogranch.com>
Re: Scanning a large binary field Sam Mason <sam@samason.me.uk>
I have a C program that reads a large binary file, and uses the read information plus some user-supplied arguments to generate an in-memory data structure that is used during the remainder of the program's execution.  I would like to adapt this code so that it gets the original binary data from a Pg database rather than a file.

One very nice feature of the original scheme is that the reading of the original file was done piecemeal, so that the full content of the file (which is about 0.2GB) was never in memory all at once, which kept the program's memory footprint nice and small.

Is there any way to replicate this small memory footprint if the program reads the binary data from a Pg DB instead of from a file?

FWIW, my OS is Linux.

TIA!

Kynn

В списке pgsql-general по дате отправления
От: Oliver Kennedy
Дата:
Сообщение: Best-N aggregates
От: John R Pierce
Дата:
FAQ