dropping and recreating indexes vs. reindexing - Mailing list pgsql-general

From Henrik Steffen
Subject dropping and recreating indexes vs. reindexing
Date
Msg-id 018d01c2917e$3e58a9a0$7100a8c0@STEINKAMP
Whole thread Raw
Responses Re: dropping and recreating indexes vs. reindexing  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
hello all,

I used to drop and recreate all user indexes once every night.
I noticed that this led to an increase of performance...

Today, using postgres-7.2.1, I wonder if this still has
benefits, or if I should better use "reindex" or if I
don't have to bother about reindexing at all ?

any information appreciated,

--

Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com          Tel. +49 4141 991230
mail: steffen@topconcepts.com       Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline:  +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
Ihr SMS-Gateway: JETZT NEU unter: http://sms.city-map.de
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------


pgsql-general by date:

Previous
From: "Henrik Steffen"
Date:
Subject: Re: what's that error?
Next
From: Çağıl Şeker
Date:
Subject: Why doesn't pgsql ask me a password ???