Mark Moellering <markmoellering@xxxxxxxxxxxxxxx> writes: <snip> > > 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. HTH > > Thanks for everyones' help and input! > > Mark Moellering > > > > -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@xxxxxxxxxxx p: 312.241.7800
