2008/3/7, Matthew <[EMAIL PROTECTED]>: > > 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 >