Re: db grows and grows

Поиск
Список
Период
Сортировка
От Varun Kacholia
Тема Re: db grows and grows
Дата
Msg-id 20020620034559.A14745@voxel.cse.iitb.ac.in
обсуждение исходный текст
Ответ на Re: db grows and grows  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
> While one can think of hacks that might be able to work around that,
> it's not clear to me that we should expend development time on making
> REINDEX slicker --- fixing the underlying space-management problem in
> btree indexes would be a better expenditure of time IMHO.  REINDEX
> is really intended for disaster recovery, not routine space management.

ah.. well if you say that REINDEX is for recovery then what should be
used for routine space management? some thing is needed if you need
regular and heavy updates and still dont wanna compromise speed.

>
>             regards, tom lane
>
--
------
Varun
If Bill Gates had a penny for every time Windows crashed......Oh wait, he does.


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How to see version of pg_dump
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Quoted identifiers in queries in plpgsql functions.