09 Sep

the problem of inserting data after creating or truncating a table

28.14K views
0
0 Comments

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
0

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