Обсуждение: Use a blob or not?
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.
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 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
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.