Use a blob or not?

On Mon, 2009-12-07 at 09:07 -0800, Daniel wrote:

I want ot store chunks of data (only about five Kb each) on a database
and have users download (across a network) these chunks to their local
disk drive. Is a blob a good way to store these chunks?

Well we don't have "blob". We have bytea and lo (which is bytea with a
different delivery and storage mechanism).

5k chunks is pretty small, bytea is probably fine.

Joshua D. Drake

Thanks.

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. - Salamander

Daniel,

If the data will only be 5 Kb, I suggest you use bytea (binary string).

Regards,
Peter Geoghegan

On December 7, 2009 12:07:49 pm Daniel wrote:

I want ot store chunks of data (only about five Kb each) on a database
and have users download (across a network) these chunks to their local
disk drive. Is a blob a good way to store these chunks?

Thanks.

Put me on the list of recommending bytea,
It works well for me, I use it for my virus database, and have noticed no
perceptable lag from ~100k samples averaging probably 100kb.

Colin
--
Best of all is never to have been born. Second best is to die soon.