On Thu, Jul 19, 2001 at 07:38:25AM +0200, [EMAIL PROTECTED] wrote:
> Since I have a number of heavy inserts per day, dropping the indexes and
> recreating them could be an option.   Only problem I see is that to
> recreate them they take alot of time, at which queries will be tremendously
> slow.

What about first creating new indexes (with a different name), and then
delete the old one? will that work?


-- 
Ragnar Kjorstad
Big Storage

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Reply via email to