Re: Loading data from one table to another

Failing to allocate a memory segment of only 1MB seems suspicious. What are your hardware specs?

You might want to look at your memory & parallel query settings in postgresql.conf--perhaps some of those are set too
highrelative to your server's memory. 

I wouldn't really expect queries to be slow on 99GB, by the way. That is not a large database. Partitioning is
reasonableif you want to prune old data periodically, as then you can just drop old partitions. But unless your queries
areregularly have to perform table scans, I wouldn't expect them to be slow. And if they are performing table scans,
you'dneed to investigate how to fix that--what indexes to add. Partitioning will get you incremental performance gains
insuch a case, while the right index will get you exponential gains.