I have a plpgsql function that I am generating from time to time, like once a week or so. What it does is it compares some phone numbers for certain prefixes and then outputs the phone numbers without the prefixes.
First I tried to make the function read from the database the prefixes, but when I tried indexing it the whole database crashed (actually it didn't crash, it just ate all resources on the computer and thus crippled it). So the solution I opted for is to recreate the function from time to time, considering that there is a small number of such prefixes to be removed. My question is: what happends if I index this function, then I change it? Does the index automatically recomputes itself or do I have to reindex manually? Thank you! ------------------------- E-Mail powered by MadNet. http://www.madnet.ro/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
