| From: | Varun Kacholia <varunk(at)cse(dot)iitb(dot)ac(dot)in> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: db grows and grows |
| Date: | 2002-06-19 22:13:19 |
| Message-ID: | 20020620034559.A14745@voxel.cse.iitb.ac.in |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-06-19 22:16:03 | Re: Quoted identifiers in queries in plpgsql functions. |
| Previous Message | Tom Lane | 2002-06-19 21:31:53 | Re: db grows and grows |