From: | Vivek Khera <khera(at)kcilink(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: database speed |
Date: | 2003-10-31 15:53:49 |
Message-ID: | x7d6cdbdyq.fsf@yertle.int.kciLink.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>>>>> "DM" == Doug McNaught <doug(at)mcnaught(dot)org> writes:
DM> The index bloat problem can occur when you have a an indexed SERIAL
DM> column whose value always increases, and you delete older rows on a
DM> regular basis. VACUUM recycles the row storage, but the index never
DM> shrinks.
I get this on tables which are updated a lot, even if I don't do any
mass deletes of older rows. The indexes on other columns also bloat
rapidly on some tables. It is a significant problem, especially since
reindex locks the tables for significant amounts of time.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
From | Date | Subject | |
---|---|---|---|
Next Message | Kolus Maximiliano | 2003-10-31 16:17:45 | Re: problem with huge joins |
Previous Message | Michael Meskes | 2003-10-31 15:33:25 | Re: Problem with ecpg |