От: Matthew
Тема: Re: Toast space grows
Дата: ,
Msg-id: Pine.LNX.4.64.0803071417290.20402@aragorn.flymine.org
(см: обсуждение, исходный текст)
Ответ на: Re: Toast space grows  ("Pavel Rotek")
Ответы: Re: Toast space grows  ("Pavel Rotek")
Список: pgsql-performance

Скрыть дерево обсуждения

Toast space grows  ("Pavel Rotek", )
 Re: Toast space grows  (Richard Huxton, )
  Re: Toast space grows  ("Pavel Rotek", )
   Re: Toast space grows  (Bill Moran, )
    Re: Toast space grows  ("Pavel Rotek", )
     Re: Toast space grows  (Alvaro Herrera, )
     Re: Toast space grows  (Tom Lane, )
      Re: Toast space grows  (Matthew, )
       Re: Toast space grows  ("Pavel Rotek", )
      Re: Toast space grows  ("Pavel Rotek", )
       Re: Toast space grows  (Matthew, )
        Re: Toast space grows  ("Pavel Rotek", )
       Re: Toast space grows  (Tom Lane, )
       Re: Toast space grows  (Bill Moran, )
        Re: Toast space grows  ("Pavel Rotek", )

On Fri, 7 Mar 2008, Pavel Rotek wrote:
> well, this will be the main problem... But... do uncomitted trasactions
> affect toast space?

I think the demonstrated answer to this is yes.

> (begin tx, load previous log, do business action, append new log, flush, do
> business action, append new log, flush, ... do business action, append new
> log, flush, commit tx).

If all you're doing is appending to the end of the log, why don't you make
each "append" a new row in a table. Instead of building massive rows, use
the database for what it was designed for, and have many smaller
independent rows.

Matthew

--
"To err is human; to really louse things up requires root
 privileges."                 -- Alexander Pope, slightly paraphrased


В списке pgsql-performance по дате сообщения:

От: Bruce Momjian
Дата:
Сообщение: Re: Effects of cascading references in foreign keys
От: Mark Kirkwood
Дата:
Сообщение: Re: count * performance issue