Re: SELECT * FROM LIMIT 1; is really slow Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: SELECT * FROM LIMIT 1; is really slow
Дата
Msg-id 40B54621.1070001@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: SELECT * FROM LIMIT 1; is really slow  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: SELECT * FROM LIMIT 1; is really slow
Список pgsql-hackers
> It wouldn't; you'd need vacuum full to collapse out the dead space.
> You could also try CLUSTER which is faster than VACUUM FULL when most
> of the data has to be moved anyway.  (Some days I think we should dump
> VACUUM FULL, because it's optimized for a case that's no longer very
> interesting...)

Out of interest, is CLUSTER another fast way of truly removing OIDs from 
a table, after going SET WITHOUT OIDS?

Chris



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Nested xacts: looking for testers and review
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: tablespaces and DB administration