Current script does this in sequence. connect pull data based on select copy/import into PG wait 30 secs connect again.
I've turned on connection logging in PG and I noticed that I keep seeing LOG : connection received statuses. Which means that the script is connecting to the server every 30s. What I don't know is.. 1. is the script using the same connection or is re-connecting afresh each time. (how can I tell?) 2. would connect_cache help in this to reduce the # of connect and re-connect to the server? Any help/comments appreciate.
