Re: index auto changes after copying data ?

From: Richard Huxton <dev(at)archonet(dot)com>
To: "energumen(at)buaa(dot)edu(dot)cn" <energumen(at)buaa(dot)edu(dot)cn>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: index auto changes after copying data ?
Date: 2005-11-29 12:16:20
Message-ID: 438C4694.3010502@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

energumen(at)buaa(dot)edu(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Chris Browne 2005-11-29 18:48:49 Re: index auto changes after copying data ?
Previous Message energumen@buaa.edu.cn 2005-11-29 07:00:22 index auto changes after copying data ?