does vacuum reclaim unused space from an index ???

Поиск
Список
Период
Сортировка
От g.p.ciceri
Тема does vacuum reclaim unused space from an index ???
Дата
Msg-id 393A8494.2233B9FF@acm.org
обсуждение исходный текст
Список pgsql-general
Hi all,
I've a small table (3000 rows) that it's UPDATEd very frequently.

create table myTable(theKey char(6) primary key, theMsg varchar(256));

Of course pgSQL does create an index on theKey, to give
me referential integrity: it seems to me that when I do
a vacuum to reclaim unused space and to speed-up the
usage of the table, the index file size is unchanged,
and so it's getting slower the update process.

Anyone may confirm me this is the default behaviour ???

TIA
/gp

--
Discussion: How do you feel about Open Source firms making
millions through public offerings?

"I wish these companies were making the same millions without
distributing any non-free, user-subjugating software." --
                                             Richard Stallman

  Gian Paolo Ciceri        Via B.Diotti 45 - 20153 Milano MI ITALY
                           eMail  :   gp.ciceri@acm.org
                           webSite:   http://www.tialabs.com

Вложения

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

Предыдущее
От: Jurgen Defurne
Дата:
Сообщение: Re: to pickle or not to pickle
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Compiling Error