470,647 Members | 1,187 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

Binary files in PGSQL

Hi!
Is it ok to store binary files within postgresql?
Won't it blow the database size up the sky?

Regards
--
Marcin "Dentharg" Gil
RLU# 221865 :: email# mgil (at) vernet pl
G-G# 185057 :: JID# dentharg (at) chrome pl
Jul 19 '05 #1
2 2522
> Is it ok to store binary files within postgresql?

Yes, I've stored .pdf files in a database before (mind you,
it was on a system with a _lot_ of storage on it [1-2 TB]).
Won't it blow the database size up the sky?


Depends on the size of the binary, but yes it will.

Sean Callaway
www.scallaway.com
Jul 19 '05 #2
W artykule <89**************************@posting.google.com >
Sean Callaway napisa≥(a):

Yes, I've stored .pdf files in a database before (mind you,
it was on a system with a _lot_ of storage on it [1-2 TB]).

My system is *a lot* smaller.. And I thought about putting
images in there.
Won't it blow the database size up the sky?


Depends on the size of the binary, but yes it will.


That's a thing I don't understand. I've read the FAQ about
size of a text file put into the db (the one with calculating
a row size of line of text). But why the DB grows so much when
putting a large object? Shouldn't it be just an allocated storage in
db file?

Regards,
--
Marcin "Dentharg" Gil
RLU# 221865 :: email# mgil (at) vernet pl
G-G# 185057 :: JID# dentharg (at) chrome pl
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by projecktzero | last post: by
8 posts views Thread by Gail Zacharias | last post: by
1 post views Thread by Victor SpŚng Arthursson | last post: by
1 post views Thread by Lynn.Tilby | last post: by
7 posts views Thread by snpe | last post: by
10 posts views Thread by joelagnel | last post: by
1 post views Thread by Korara | last post: by
reply views Thread by warner | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.