Re: [HACKERS] GiST notice

2005-07-06 Thread Oleg Bartunov
On Wed, 6 Jul 2005, Joshua D. Drake wrote: Teodor Sigaev wrote: It should be mentioned in documentation that after pgsql's crash GiST indexes may restore some "incorrect way": with invalid tuples. Of course, not every time. Index will work absolutly correct but possibly with some performance

Re: [HACKERS] GiST notice

2005-07-06 Thread Joshua D. Drake
Teodor Sigaev wrote: It should be mentioned in documentation that after pgsql's crash GiST indexes may restore some "incorrect way": with invalid tuples. Of course, not every time. Index will work absolutly correct but possibly with some performance degradation (not big). 'Vacuum full' resolves

[HACKERS] GiST notice

2005-07-06 Thread Teodor Sigaev
It should be mentioned in documentation that after pgsql's crash GiST indexes may restore some "incorrect way": with invalid tuples. Of course, not every time. Index will work absolutly correct but possibly with some performance degradation (not big). 'Vacuum full' resolves this problem and repa