From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Vacuum only with 20% old tuples |
Date: | 2000-07-12 00:40:50 |
Message-ID: | 200007120040.UAA27940@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I suggest that we change vacuum to only move remove tuples if there is
more than 20% expired tuples.
When we do vacuum, we drop all indexes and recreate them.
This fixes the complaint about vacuum slowness when there are many
expired rows in the table. We know this is causes by excessive index
updates. It allows indexes to shrink (Jan pointed this out to me.) And
it fixes the TOAST problem with TOAST values in indexes.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew McMillan | 2000-07-12 00:48:49 | Re: [GENERAL] Slashdot discussion |
Previous Message | Tim Perdue | 2000-07-12 00:35:52 | Serious Performance Loss in 7.0.2?? |