"Pavel Rotek" <pavel.rotek@gmail.com> writes:
> 2008/3/7, Tom Lane <tgl@sss.pgh.pa.us>:
>> You mean that you build up the 5MB log entry by adding a few lines at a
>> time? That's going to consume horrid amounts of toast space, because
>> each time you add a few lines, an entire new toasted field value is
>> created.
> well, this will be the main problem... But... do uncomitted trasactions
> affect toast space?
Sure. Where do you think the data goes? It's gotta be stored
someplace. Every UPDATE operation that changes a toasted field will
consume space for a fresh copy of that field, whether it ever commits or
not. You need VACUUM to reclaim the space eaten by no-longer-accessible
copies.
regards, tom lane