Re: Any risk in increasing BLCKSZ to get larger tuples?

Поиск
Список
Период
Сортировка
От Philip Hallstrom
Тема Re: Any risk in increasing BLCKSZ to get larger tuples?
Дата
Msg-id Pine.BSF.4.21.0010191541380.50734-100000@oddjob.adhesivemedia.com
обсуждение исходный текст
Ответ на Re: Any risk in increasing BLCKSZ to get larger tuples?  (Joseph Shraibman <jks@selectacast.net>)
Список pgsql-general
[stuff about why 7.1 isn't out and the 8K limit and TOAST AND WAL snipped]

> And do you really think that WAL is more important that TOAST?  I
> imagine a good percentage of users bump up against the 8K limit and end
> up with corrupted data (like I did) but much fewer think that WAL is a
> critical feature.

If I had to pick I would rather have WAL over TOAST.  I originally asked
the question about BLCKSZ and this is the first app that I am worried
about hitting that limit.  It's actually never even crossed my mind before
this since usually if it's big it's an image and I just store it on disk
with a filename in the database.  And I would say for a lot of web uses 8K
(or the 32K max) is way more than adequate.
    WAL on the other hand would be really nice because even if my data
is small, it sure would be nice to reproduce it in the case of a monstrous
crash.

just my 2 cents.


-philip


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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: rules *very* slow?
Следующее
От: "Edmar Wiggers"
Дата:
Сообщение: RE: prefer (+) oracle notation