Re: [GENERAL] Many BLOb;s - Mailing list pgsql-general

From Zakkr
Subject Re: [GENERAL] Many BLOb;s
Date
Msg-id Pine.LNX.3.96.991007082514.17754A-100000@ara.zf.jcu.cz
Whole thread Raw
In response to Many BLOb;s  ("Nikolay Mijaylov" <nmmm@nmmm.nu>)
List pgsql-general

On Thu, 7 Oct 1999, Nikolay Mijaylov wrote:

> Hi all,
>
> currently I have project that i;ll use Postgre table with up to 100 000 (or
> more) records, and every record will contain BLOb (Postgre type "oid").
> Every BLOb will be different kind of document, from plain text to GIF or
> JPEG image or some other binary data (MsWord, WP, EXE files etc...)
>
> Is there something risk when I do this? I mean many databases do not support
> BLOb;s too good?


 Do you want indexing/search in EXE/WP/M$ files? (Probably no..)

 We have in PostgreSQL large object (lo) API for big and "non-scanning" data.
See the tutorial for more information.

                            Zakkr


pgsql-general by date:

Previous
From: "Nikolay Mijaylov"
Date:
Subject: Many BLOb;s
Next
From: "Natalya S. Makushina"
Date:
Subject: what does this mean - pg_psort.1922.0 in database directory?