[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 copy in case the
statistics about how many different values are present changes.

-- 
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to