RE: Parallel Inserts in CREATE TABLE AS

From: Dilip Kumar <dilipbalaut@gmail.com> 
Basically you are creating a new table and loading data to it and that means you will be less likely to access those
datasoon so for such thing spoiling buffer cache may not be a good idea.
 
--------------------------------------------------

Some people, including me, would say that the table will be accessed soon and that's why the data is loaded quickly
duringminimal maintenance hours.
 


--------------------------------------------------
I was just suggesting only for experiments for identifying the root cause.
--------------------------------------------------

I thought this is a good chance to possibly change things better (^^).
I guess the user would simply think like this: "I just want to finish CTAS as quickly as possible, so I configured to
takeadvantage of parallelism.  I want CTAS to make most use of our resources.  Why doesn't Postgres try to limit
resourceusage (by using the ring buffer) against my will?"
 


Regards
Takayuki Tsunakawa