Any risk in increasing BLCKSZ to get larger tuples?

Поиск
Список
Период
Сортировка
От Philip Hallstrom
Тема Any risk in increasing BLCKSZ to get larger tuples?
Дата
Msg-id Pine.BSF.4.21.0010181444450.39346-100000@oddjob.adhesivemedia.com
обсуждение исходный текст
Ответы Re: Any risk in increasing BLCKSZ to get larger tuples?  (Neil Conway <nconway@klamath.dyndns.org>)
Re: Any risk in increasing BLCKSZ to get larger tuples?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi -
    I'm thinking about using postgres for an app that will store
various email messages which might (although probably not likely) be
larger than the builtin limit for tuples.  Is there anything I should be
aware of before changing the below value and recompiling?

Also, it looks like the TOAST stuff would solve this (right/wrong?), but
it's not going to be ready for 7.1 (right/wrong?)

Thanks!

from src/include/config.h
/*
 * Size of a disk block --- currently, this limits the size of a tuple.
 * You can set it bigger if you need bigger tuples.
 */
/* currently must be <= 32k bjm */
#define BLCKSZ  8192




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

Предыдущее
От: Neil Conway
Дата:
Сообщение: rules *very* slow?
Следующее
От: Neil Conway
Дата:
Сообщение: Re: Any risk in increasing BLCKSZ to get larger tuples?