Re: Index grows huge, possible leakage?
От | XuYifeng |
---|---|
Тема | Re: Index grows huge, possible leakage? |
Дата | |
Msg-id | 000b01c08cc4$d3c007b0$6201a8c0@William обсуждение исходный текст |
Ответ на | Index grows huge, possible leakage? (Alfred Perlstein <bright@wintelcom.net>) |
Список | pgsql-hackers |
PostgreSQL hasn't a rewritten storage managent, this is a normal case. Regards XuYifeng ----- Original Message ----- From: "Alfred Perlstein" <bright@wintelcom.net> To: <pgsql-hackers@postgresql.org> Cc: "Mikheev, Vadim" <vmikheev@SECTORBASE.COM> Sent: Friday, February 02, 2001 7:34 AM Subject: [HACKERS] Index grows huge, possible leakage? > After several weeks our idicies grow very large (in one case to > 4-5 gigabytes) After droppping and recreating the indecies they > shrink back to something more reasonable (500megs same case). > > We are currently using Vadim's vacuum patches for VLAZY and MMNB, > against 7.0.3. We are using a LAZY vacuum on these tables > > However a normal (non-lazy) vacuum doesn't shrink the index, the > only thing that helps reduce the size is dropping and recreating. > > Is this a bug in 7.0.3? A possible bug in Vadim's patches? Or is > this somewhat expected behavior that we have to cope with? > > As a side note, the space requirement is actually 'ok' it's just > that performance gets terrible once the indecies reach such huge > sizes. > > -- > -Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org] > "I have the heart of a child; I keep it in a jar on my desk." >
В списке pgsql-hackers по дате отправления: