Re: To BLOB Or Not To BLOB

Поиск
Список
Период
Сортировка
От Peter Mount
Тема Re: To BLOB Or Not To BLOB
Дата
Msg-id Pine.LNX.4.10.10004172028160.6375-100000@maidast.retep.org.uk
обсуждение исходный текст
Ответ на Re: To BLOB Or Not To BLOB  ("Adam Ruth" <aruth@intercation.com>)
Список pgsql-general
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.

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 по дате отправления:

Предыдущее
От: Hal Snyder
Дата:
Сообщение: excell to postgres
Следующее
От: Jeffrey
Дата:
Сообщение: Re: excell to postgres