Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCHES] GIN improvements - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: [PATCHES] GIN improvements
Date
Msg-id 4942A137.3000502@sigaev.ru
Whole thread Raw
In response to Re: [PATCHES] GIN improvements  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: [PATCHES] GIN improvements  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-hackers
Tree view 
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/
Attachment

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: benchmarking the query planner
Next
From: Markus Wanner
Date:
Subject: Re: Multiplexing SUGUSR1