👋 I’m relative newbie over here, running meltano on a box and pushing to a postgres target on google cloud sql. i generally see really high usage on CPU #1 and relatively low on CPU #2 on the postgres server, is there anything i can do in meltano to configure it to spin up more connections so that the load is more evenly shared?

Hi @tim_schwartz! I don't think there's currently any way of configuring that at the moment, but I'm very interested in improving connection pooling in MeltanoLabs/target-postgres (eg #140). cc @visch

I'm interested in how to optimize connections with CPU usage for a Postgres server. My approach for that has always been "let the DB figure out how to properly parallelize its stuff". Definitely something that'd be interesting to dive into more, I'd start with just some basic performance benchmarks of whatever you're trying to increase the speed of. Some kind of benchmarking script would be the place to start here

thanks, yeah i’ve always just been of the mindset “let the db figure it out” but it just doesnt appear to be living up to its potential currently 🙂