On Aug 23, 2007, at 12:00 AM, Tony Caduto wrote:
Check it out here:
http://www.amsoftwaredesign.com/pg_vs_fb
When comparing in the grid the only major advantage FB has is
probably BLOB support.
PG only suppports 1 gb while FB supports 32gb. Bytea is pretty
slow as well when compared to the FB BLOB support.
Actually, Postgres's large object facility allows storage of binary
data up to 2GB in size. http://www.postgresql.org/docs/8.2/
interactive/largeobjects.html
Erik Jones
Software Developer | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
