Mark Moellering <markmoeller...@psyberation.com> writes:
> How long can you run COPY? I have been looking at it more closely.
> In some ways, it would be simple just to take data from stdin and
> send it to postgres but can I do that literally 24/7? I am
> monitoring data feeds that will never stop and I don't know if that
> is how Copy is meant to be used or if I have to let it finish and
> start another one at some point?
Launch a single copy and pipe data into it for an extended period an/or
bulk is fine but nothing will be visible until the statement is finished
and, if it were run in a transaction block, the block committed.
> Thanks for everyones' help and input!
> Mark Moellering
Postgres DBA/Development Consulting