Re: realtime data inserts

Doug McNaught wrote:
> Ron Johnson <ron.l.johnson@cox.net> writes:
> 
> 
>>On Sat, 2003-05-10 at 21:46, Tom Lane wrote:
>>
>>>Ron Johnson <ron.l.johnson@cox.net> writes:
>>>
>>>>On Sat, 2003-05-10 at 11:00, Tom Lane wrote:
>>>>
>>>>>Have you thought about using COPY?
>>>
>>>>Generate a temporary file, and then system("COPY /tmp/foobar ...") ?
>>>
>>>No, copy from stdin.  No need for a temp file.
>>
>>But wouldn't that only work if the input stream is acceptable to
>>COPY ?
> 
> 
> Yes, but you could always pipe it through a script or C program to
> make it so...

lets say I have an about 1kb/s continuus datastream comming in for many 
hours and I'd like to store this data in my db using COPY table FROM stdin.

At what time should I COMMIT or close the stream to feed the database 
and COPY FROM again?