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
- [ADMIN] Requirements for a database server Robert . Farrugia
- Re: [ADMIN] Requirements for a database server Ross J. Reedstrom
- Re: [ADMIN] Requirements for a database server Tom Lane
- Re: [ADMIN] Requirements for a database server Ron Chmara
- Re: [ADMIN] Requirements for a database server Robert . Farrugia
- Re: [ADMIN] Requirements for a database server Robert . Farrugia
- Re: [ADMIN] Requirements for a database server Robert . Farrugia
- Re: [ADMIN] Requirements for a database server Ragnar Kjørstad
- Re: [ADMIN] Requirements for a database server Robert . Farrugia
- Re: [ADMIN] Requirements for a database server Robert . Farrugia
- Re: [ADMIN] Requirements for a database server Robert . Farrugia