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
--------------------------------------------------------
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? |