Orlando Andico wrote:
>
> On Fri, 9 Mar 2001, Mary Christie Generalao wrote:
> ..
> PostgreSQL sucks for BLOB data -- there is a VARCHAR which functions
> similarly to a CLOB in Oracle, but as of Pg 7.0 and down, there is a 32K
> row limit *make a face* anyway, Great Bridge is releasing 7.1 is a few
> weeks and allegedly it has mucho larger row support.
>
> Even so, Pg stores each table as a file, +1 file per indexed column. That
> means, your maximum table size is 2GB (due to 2GB file size limit on
> Linux). Yes, 2.4 and glibc2.2 have Large File Summit support, but I don't
> know if Pg supports it.
No it doesn't support it. It doesn't have to because it splits files at
1 GB boundaries.
> Finally, I have discovered that Pg has VERY sucky concurrency on
> UPDATES. Yes, inserts are fast (faster than Oracle) and straight selects
> are fast too. But do a bulk UPDATE.. it's about 2 orders of magnitude
> slower than Oracle.
I haven't noticed. My apps use mostly INSERTS. UPDATES account for
probably 1% of all transactions.
> I don't want to sound like a spoiled-brat Oracle zealot: of all the
> open-source databases I've used, Pg has the best feature set. But it still
> falls short in several areas. I would use Pg if I needed adequate
> concurrency, transactional commit, and fairly complex queries, but
> couldn't afford Oracle. I would use MySQL if I really need BLOB support
> but ACID be damned.
> I would use Oracle for things that the open-source products can't do.
Hear, hear.
> Christie, if I were you, unless you have a compelling reason to use a BLOB
> (e.g. you want to index it, something Pg can't do either..) I would
> suggest you store the binary data in the FILESYSTEM. Something like the
> Oracle BFILE data type. It will save you some headaches.
Realistically, this is the only way to store binary data in a
platform-independent manner.
Brian
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
