Thanks for the starter checklist. I started high speed database work with PostgreSQL for trading. Purchased second resolution history on how high alpha stocks move, wrote a Java Automated Trading System that looked for patterns in how the whale banks staggered their trades. Back tested it over and over on that data set, thus the need for a fast database. Executed day trades against the live market for just over a year. It made money. Only shut it down because my mom needed help after an injury and it took round the clock work to keep the system going. The R&D on that project had me read every major book on trading and speculation theory then on the market. Tossed about 100 obsolete trading books last week.
Part of why I'm here on Hive is to explore monetizing my writing while reviving my trading. Alternatives like Substack are interesting, I just try to avoid business with Venture Capital controlled software companies or ones with tightly controlled and/or closed source code. Hive checks most of my boxes.
RE: Speeding up PostgreSQL data loading