Re: Index bloat in 7.2
От | Julian Scarfe |
---|---|
Тема | Re: Index bloat in 7.2 |
Дата | |
Msg-id | 089a01c4db70$4e34cdc0$0600a8c0@Wilbur обсуждение исходный текст |
Ответ на | Index bloat in 7.2 ("Julian Scarfe" <julian.scarfe@ntlworld.com>) |
Ответы |
Re: Index bloat in 7.2
|
Список | pgsql-general |
From: "Christopher Browne" <cbbrowne@acm.org> > The "empty pages not reclaimed" problem is something that did indeed > get fixed in the post-7.2 days. I _think_ it was 7.4, but it might > have been 7.3. > In short, 7.4.x is indeed a good resolution to your issue. From: "Tom Lane" <tgl@sss.pgh.pa.us> > > That's exactly what I'd expect ... Thanks both. So it sounds like: a) the issue is controllable with a regular (and in our case, just occasional) reindex without any long term negative consequences b) Only a dump-restore major version upgrade (which we'll do next time we can take the system out for long enough) will avoid the issue. Julian
В списке pgsql-general по дате отправления: