Ok thanks everybody for the calrification, after all now I allready learned something new... ;)
My employer is currently thinking about migration to 8.2.x because of your feedback, so I think that the problem could be resolved... ;) Thanks to everyone... Sven Clement 2007/8/6, Heikki Linnakangas <[EMAIL PROTECTED]>: > > Sven Clement wrote: > > Partially I found that one in the PostgreSQL Documentation for the > > 7.x.xversions under the command REINDEX where they claim that you > > should run a > > reindex under certain circumstances and for my comprehension this says > that > > with some access pattern (as ours (major writes / one big delete per > day)) > > the index may be corrupted or otherwise not really useful. > > Up to 7.3, periodical REINDEX was needed to trim down bloated indexes. > Since 7.4, empty index pages are recycled so that's no longer necessary. > You can still end up with larger than necessary indexes in recent > versions under unusual access patterns, like if you delete all but a few > index tuples from each index page, but it's rare in practice. And it's > not unbounded growth like in <= 7.3. > > In any case, the indexes won't become corrupt. > > -- > Heikki Linnakangas > EnterpriseDB http://www.enterprisedb.com > -- DSIGN.LU Sven Clement +352 621 63 21 18 [EMAIL PROTECTED] www.dsign.lu
