Re: remove flatfiles.c
От | Alvaro Herrera |
---|---|
Тема | Re: remove flatfiles.c |
Дата | |
Msg-id | 20090901230134.GB7243@alvh.no-ip.org обсуждение исходный текст |
Ответ на | Re: remove flatfiles.c (Greg Stark <gsstark@mit.edu>) |
Ответы |
Re: remove flatfiles.c
|
Список | pgsql-hackers |
Greg Stark wrote: > The use cases where VACUUM FULL wins currently are where storing two > copies of the table and its indexes concurrently just isn't practical. Yeah, but then do you really need to use VACUUM FULL? If that's really a problem then there ain't that many dead tuples around. > Also perhaps tables where there are too many large indexes to make > rebuilding them all in one maintenance window practical. If that's the concern maybe we oughta do something about concurrently re-creating those indexes somehow. Plain REINDEX doesn't work of course, but maybe we can do some trick with creating a new index and dropping the original one afterwards. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
В списке pgsql-hackers по дате отправления: