Re: Requirements for a database server - Mailing list pgsql-admin

From Ragnar Kjørstad
Subject Re: Requirements for a database server
Date
Msg-id 20010719194500.B8237@vestdata.no
Whole thread Raw
In response to Re: Requirements for a database server  (Robert.Farrugia@go.com.mt)
Responses Re: Requirements for a database server
List pgsql-admin
On Thu, Jul 19, 2001 at 07:38:25AM +0200, Robert.Farrugia@go.com.mt 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

pgsql-admin by date:

Previous
From: Edipo Elder Fernandes de Melo
Date:
Subject: Re: Password file for autent
Next
From: Tom Lane
Date:
Subject: Re: Requirements for a database server