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;;
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/>
In response to
pgsql-performance by date
|Next:||From: Franklin Haut||Date: 2005-11-30 13:35:05|
|Subject: pg_dump slow|
|Previous:||From: Richard Huxton||Date: 2005-11-29 12:16:20|
|Subject: Re: index auto changes after copying data ?|