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 95CBD9DCBB7 for ; Tue, 29 Nov 2005 15:04:10 -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 17436-05 for ; Tue, 29 Nov 2005 15:04:09 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id F266E9DCADF for ; Tue, 29 Nov 2005 15:04:06 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 752643358C; Tue, 29 Nov 2005 20:04:07 +0100 (MET) From: Chris Browne X-Newsgroups: pgsql.performance Subject: Re: index auto changes after copying data ? Date: Tue, 29 Nov 2005 13:48:49 -0500 Organization: cbbrowne Computing Inc Lines: 19 Message-ID: <60zmnn1e9a.fsf@dba2.int.libertyrms.com> References: <20051129065944.8294B37F78@mx2.buaa.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.17 (Jumbo Shrimp, linux) Cancel-Lock: sha1:p2ywLvgGkAWWRVpnxWqLIcB/rpA= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.142 required=5 tests=[AWL=0.142] X-Spam-Score: 0.142 X-Spam-Level: X-Archive-Number: 200511/552 X-Sequence-Number: 15809 energumen@buaa.edu.cn ("energumen@buaa.edu.cn") writes: > 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? Do you mean, by this, something like... "Are indexes affected by loading data using the COPY command just as they are if data is loaded using INSERT?" If so, then the answer is "Yes, certainly." Indexes are updated whichever statement you use to load in data. -- let name="cbbrowne" and tld="acm.org" in name ^ "@" ^ tld;; http://www.ntlug.org/~cbbrowne/finances.html Rules of the Evil Overlord #160. "Before being accepted into my Legions of Terror, potential recruits will have to pass peripheral vision and hearing tests, and be able to recognize the sound of a pebble thrown to distract them."