Re: To BLOB Or Not To BLOB

Поиск
Список
Период
Сортировка
От Peter Mount
Тема Re: To BLOB Or Not To BLOB
Дата
Msg-id Pine.LNX.4.10.10004181804300.4529-100000@maidast.retep.org.uk
обсуждение исходный текст
Ответ на Re: To BLOB Or Not To BLOB  (Lincoln Yeoh <lylyeoh@mecomb.com>)
Список pgsql-general
On Tue, 18 Apr 2000, Lincoln Yeoh wrote:

> At 08:29 PM 17-04-2000 +0100, Peter Mount wrote:
> >On Mon, 17 Apr 2000, Adam Ruth wrote:
> >
> >> > I'm using Linux and ext2fs has a 2GB limit on files, and it seems like
> >> > 6.5.3 tables are stored as single files, so better not go down that path
> >> :).
> >>
> >> I'm using 6.5.2 and it will split a table among several files, so that's
> not
> >> a problem.  Though I'm not sure how BLOBs are stored since I never use
> them.
> >
> >BLOBS are currently implemented as a table/index pair, so they will split
> >at the 1Gb mark as do normal tables.
>
> Oh.. Ah well, maybe with my next version/app then. Where was it mentioned
> in the docs? Would like to look at the details.

I'm not sure about the docs, but look at the storage manager portion of
the source. It's pretty well documented in there.

Peter

--
       Peter T Mount peter@retep.org.uk
      Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
 Java PDF Generator: http://www.retep.org.uk/pdf


В списке pgsql-general по дате отправления:

Предыдущее
От: Thomas Lockhart
Дата:
Сообщение: Re: [HACKERS] Struggles with RC1 and RPMS
Следующее
От: "Michael S. Kelly"
Дата:
Сообщение: Starting a new project, any opinions about using 7.0?