Re: [HACKERS] Deferred trigger queue

wieck(at)debis(dot)com (Jan Wieck) writes:
> looking at all the complications about dealing with segmented
> files etc., I wonder if it's really worth the efford to add
> file buffering to the trigger queue.

You shouldn't be thinking about that. Use a BufFile (see
src/include/storage/buffile.h), and you have temp file creation,
file segmentation and auto cleanup at xact abort with no more work
than fopen/fwrite would be. See nodeHash.c/nodeHashjoin.c for an
example of use.

> Of course, if someone updates millions of rows in an RI
> scenario during one transaction, it could blow away the
> backend. But I'd prefer to leave this as a well known problem
> for 7.1 and better start on creating a good regression test
> and some documentation for it.

However, if you think that there are other tasks that are higher
priority than this one, I won't argue.

regards, tom lane