Re: db grows and grows - Mailing list pgsql-general

From Varun Kacholia
Subject Re: db grows and grows
Date
Msg-id 20020620034559.A14745@voxel.cse.iitb.ac.in
Whole thread Raw
In response to Re: db grows and grows  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to see version of pg_dump
Next
From: Tom Lane
Date:
Subject: Re: Quoted identifiers in queries in plpgsql functions.