By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,302 Members | 1,244 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,302 IT Pros & Developers. It's quick & easy.

Binary files in PGSQL

P: n/a
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
Share this Question
Share on Google+
2 Replies

P: n/a
> 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

P: n/a
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.