[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