Postgres Pro
Downloads
Home   >   mailing lists

Re: index auto changes after copying data ? - Mailing list pgsql-performance

From Richard Huxton
Subject Re: index auto changes after copying data ?
Date
Msg-id 438C4694.3010502@archonet.com
Whole thread Raw
In response to index auto changes after copying data ?  ("energumen@buaa.edu.cn" <energumen@buaa.edu.cn>)
List pgsql-performance
Tree view 
energumen@buaa.edu.cn 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

pgsql-performance by date:

Previous
From: "energumen@buaa.edu.cn"
Date:
Subject: index auto changes after copying data ?
Next
From: Chris Browne
Date:
Subject: Re: index auto changes after copying data ?