Re: Modifying TOAST thresholds

Поиск
Список
Период
Сортировка
От Chris Browne
Тема Re: Modifying TOAST thresholds
Дата
Msg-id 60wszyaqrw.fsf@dba2.int.libertyrms.com
обсуждение исходный текст
Ответ на Re: Modifying TOAST thresholds  (Gregory Stark <stark@enterprisedb.com>)
Ответы Re: Modifying TOAST thresholds  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
bruce@momjian.us (Bruce Momjian) writes:
> I have seen no one do peroformance testing of this, so it seems it
> will have to wait for 8.4.

I didn't have time...

I'll see if I can find a decent place to document how to tweak the
threshold, as that seems like it could be worth doing in cases where
it is known that there is benefit to TOASTing smaller tuples for one's
well-understood workload.

(e.g. - we've got a case where dropping the threshold to ~900 bytes
would give us a big win for certain databases and tables.)
-- 
let name="cbbrowne" and tld="linuxfinances.info" in name ^ "@" ^ tld;;
http://linuxfinances.info/info/unix.html
recursion, n:       See recursion.


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Fwd: How does the partitioned lock manager works?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [Fwd: PGBuildfarm member narwhal Branch HEAD Status changed from OK to InstallCheck failure]