X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 95DC89DD600 for ; Tue, 29 Nov 2005 03:33:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 00746-01-4 for ; Tue, 29 Nov 2005 03:33:40 -0400 (AST) X-Greylist: delayed 00:31:09.386303 by SQLgrey- Received: from mx2.buaa.edu.cn (mx2.buaa.edu.cn [219.239.227.26]) by postgresql.org (Postfix) with ESMTP id 2471C9DD557 for ; Tue, 29 Nov 2005 03:31:38 -0400 (AST) Received: from mx1.buaa.edu.cn (mx1.buaa.edu.cn [192.168.128.5]) by mx2.buaa.edu.cn (Postfix) with ESMTP id 8294B37F78 for ; Tue, 29 Nov 2005 14:59:44 +0800 (CST) Received: from [203.86.95.74] by 10.0.0.130 with StormMail ESMTP id 99741.1939646864; Tue, 29 Nov 2005 15:52:07 +0800 (CST) Date: Tue, 29 Nov 2005 15:00:22 +0800 From: "energumen@buaa.edu.cn" To: "pgsql-performance" Subject: index auto changes after copying data ? X-mailer: Foxmail 5.0 [cn] Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 7bit Message-Id: <20051129065944.8294B37F78@mx2.buaa.edu.cn> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=4.813 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879, RCVD_DOUBLE_IP_SPAM=3.455] X-Spam-Score: 4.813 X-Spam-Level: **** X-Archive-Number: 200511/550 X-Sequence-Number: 15807 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?