Horton

Re: [PATCHES] GIN improvements

Teodor Sigaev <teodor@sigaev.ru>

View thread View on postgr.es
From: Teodor Sigaev <teodor@sigaev.ru>
To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2008-12-12T17:36:55Z
Lists: pgsql-hackers

Attachments

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@sigaev.ru
                                                    WWW: http://www.sigaev.ru/