09 Sep

the problem of inserting data after creating or truncating a table


I meets a problem when using the greenplum, and I need help.
After creating or truncating a table, when I insert or copy some data to the table at the first,
that won’t be finished in a few minutes.
And I stop that operating , then inserting or copying ,
that will succeed in a few hundred milliseconds.

So How should I solve this problem, please.

Thank you very much!

deleted answer

im a little confused by the question – are you saying that the first load to a table takes longer than subsequent loads? how are you inserting the data?

Head of Data for Pivotal