| From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Add pages deleted from pending list to FSM |
| Date: | 2015-09-07 13:29:19 |
| Message-ID: | E1ZYwU3-00054w-Gb@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
Add pages deleted from pending list to FSM
Add pages deleted from GIN's pending list during cleanup to free space map
immediately. Clean up process could be initiated by ordinary insert but adding
page to FSM might occur only at vacuum. On some workload like never-vacuumed
insert-only tables it could cause a huge bloat.
Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/e95680832854cf300e64c10de9cc2f586df558e8
Modified Files
--------------
src/backend/access/gin/ginfast.c | 23 +++++++++++++++++++++++
1 file changed, 23 insertions(+)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Teodor Sigaev | 2015-09-07 14:22:02 | pgsql: Make GIN's cleanup pending list process interruptable |
| Previous Message | Greg Stark | 2015-09-07 12:39:41 | Re: [COMMITTERS] pgsql: Move DTK_ISODOW DTK_DOW and DTK_DOY to be type UNITS rather than |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2015-09-07 13:34:10 | Re: Speed up Clog Access by increasing CLOG buffers |
| Previous Message | Alexander Korotkov | 2015-09-07 13:28:40 | Re: WIP: Access method extendability |