From: | Chris Browne <cbbrowne(at)acm(dot)org> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: index auto changes after copying data ? |
Date: | 2005-11-29 18:48:49 |
Message-ID: | 60zmnn1e9a.fsf@dba2.int.libertyrms.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
energumen(at)buaa(dot)edu(dot)cn ("energumen(at)buaa(dot)edu(dot)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." <http://www.eviloverlord.com/>
From | Date | Subject | |
---|---|---|---|
Next Message | Franklin Haut | 2005-11-30 13:35:05 | pg_dump slow |
Previous Message | Richard Huxton | 2005-11-29 12:16:20 | Re: index auto changes after copying data ? |