Postgres for BLOB ?

Postgres for BLOB ?

am 21.05.2010 23:00:08 von Balkrishna Sharma

--_37042670-db67-4631-89db-801821d17905_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Hello=2C
How does postgres perform with large object (pdf=2Cword docs=2Cimages=2Cmp3=
=2Cmp4) storage ? For my system=2C individual object size will be at max a =
few MBs with most objects being less than a MB. Also between "TOAST" and "l=
arge objects" what is more preferred ?What are the other alternatives (file=
systems=2C other open databases for contents ...) ?
Thanks=2C-Bala

=20
____________________________________________________________ _____
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with H=
otmail.=20
http://www.windowslive.com/campaign/thenewbusy?tile=3Dmultic alendar&ocid=3D=
PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5=

--_37042670-db67-4631-89db-801821d17905_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






Hello=2C


How does postgres perform with large object (pd=
f=2Cword docs=2Cimages=2Cmp3=2Cmp4) storage ? For my system=2C individual o=
bject size will be at max a few MBs with most objects being less than a MB.=
 =3B
Also between "TOAST" and "large objects" what is more pr=
eferred ?
What are the other alternatives (file systems=2C other =
open databases for contents ...) ?

Thanks=2C
=
-Bala




The N=
ew Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmai=
l. alendar&ocid=3DPID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010 _5' target=3D'_=
new'>Get busy.

=

--_37042670-db67-4631-89db-801821d17905_--