Re: postgresql storage and performance questions

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: postgresql storage and performance questions
Дата
Msg-id AFCE607D-C302-4D7D-8B49-83A46551DF00@kcilink.com
обсуждение исходный текст
Ответ на Re: postgresql storage and performance questions  ("Josh Harrison" <joshques@gmail.com>)
Список pgsql-general
On Nov 20, 2007, at 1:04 PM, Josh Harrison wrote:

> I ran vacuum full on this table already. I haven't re-indexed it. But
> this will not affect the table size...right...since indexes are stored
> separately?
>>

Yes, but your indexes are probably bloated at this point, so to reduce
the space they use run a reindex.


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

Предыдущее
От: Brad Nicholson
Дата:
Сообщение: Re: postgresql storage and performance questions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: possible to create multivalued index from xpath() results in 8.3?