the problem of inserting data after creating or truncating a table

charnan (anonymous)

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!


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?

Write your answer..