| From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
|---|---|
| To: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [PATCHES] GIN improvements |
| Date: | 2008-12-12 17:36:55 |
| Message-ID: | 4942A137.3000502@sigaev.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Changes:
- added vacuum_delay_point() in gininsertcleanup
- add trigger to run vacuum by number of inserted tuples from
last vacuum. Number of inserted tuples represents number
of really inserted tuples in index and it is calculated as
tuples_inserted + tuples_updated - tuples_hot_updated.
Trigger fires on instuples > vac_base_thresh because search time is linear
on number of pending pages (tuples)
--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/
| Attachment | Content-Type | Size |
|---|---|---|
| fast_insert_gin-0.17.gz | application/x-tar | 21.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Wanner | 2008-12-12 17:40:03 | Re: Multiplexing SUGUSR1 |
| Previous Message | Simon Riggs | 2008-12-12 17:33:29 | Re: benchmarking the query planner |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2008-12-15 17:49:08 | Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1 |
| Previous Message | Emmanuel Cecchet | 2008-12-10 00:51:05 | Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1 |