2008/3/7, Matthew <matthew@xxxxxxxxxxx>:
Because I modify existing application, where logic is already given :-(. If no other way exists, i'll have to do refactoring...
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
Because I modify existing application, where logic is already given :-(. If no other way exists, i'll have to do refactoring...
--
"To err is human; to really louse things up requires root
privileges." -- Alexander Pope, slightly paraphrased
