Binary files in PGSQL

[Marcin Gil]

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

[Sean Callaway]

> 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

[Marcin Gil]

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