[EMAIL PROTECTED] ("[EMAIL PROTECTED]") writes:
> I know in mysql, index will auto change after copying data Of
> course, index will change after inserting a line in postgresql, but
> what about copying data?
Do you mean, by this, something like...
"Are indexes affected by loading data using the
[EMAIL PROTECTED] wrote:
> I know in mysql, index will auto change after copying data
> Of course, index will change after inserting a line in postgresql, but what
> about copying data?
The index will (of course) know about the new data.
You might want to ANALYZE the table again after a large cop
