Re: remove flatfiles.c
От | Alvaro Herrera |
---|---|
Тема | Re: remove flatfiles.c |
Дата | |
Msg-id | 20090902025846.GD7243@alvh.no-ip.org обсуждение исходный текст |
Ответ на | Re: remove flatfiles.c (Robert Haas <robertmhaas@gmail.com>) |
Ответы |
Re: remove flatfiles.c
|
Список | pgsql-hackers |
Robert Haas escribió: > On Tue, Sep 1, 2009 at 7:42 PM, Tom Lane<tgl@sss.pgh.pa.us> wrote: > > But trying to VACUUM FULL that table is going to be horridly painful > > too, and you'll still have bloated indexes afterwards. You might as > > well just live with the 50% waste, especially since if you did a > > full-table update once you'll probably do it again sometime. > > > > I'm having a hard time believing that VACUUM FULL really has any > > interesting use-case anymore. > > What if your large table doesn't have an index? Then there's no way to cluster. But there's nothing saying we cannot provide a version of CLUSTER that does not follow any index and just copies the live tuples. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
В списке pgsql-hackers по дате отправления: