dropping and recreating indexes vs. reindexing

From: "Henrik Steffen" <steffen(at)city-map(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: dropping and recreating indexes vs. reindexing
Date: 2002-11-21 16:51:31
Message-ID: 018d01c2917e$3e58a9a0$7100a8c0@STEINKAMP
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)topconcepts(dot)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
--------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Çağıl Şeker 2002-11-21 16:59:14 Why doesn't pgsql ask me a password ???
Previous Message Henrik Steffen 2002-11-21 16:48:21 Re: what's that error?