On Fri, Sep 11, 2015 at 7:52 AM, Костя Кузнецов <chapae...@ya.ru> wrote: > old version: > > INFO: vacuuming "public.point_tbl" > INFO: scanned index "gpointind" to remove 11184520 row versions > DETAIL: CPU 84.70s/72.26u sec elapsed 27007.14 sec. > [...] > > new vacuum is about > INFO: vacuuming "public.point_tbl" > INFO: scanned index "gpointind" to remove 11184520 row versions > DETAIL: CPU 13.00s/27.57u sec elapsed 1864.22 sec. > [...] > There is a big speed up + we can reuse some pages.
Indeed. Interesting. You should definitely add your patch to the next commit fest: https://commitfest.postgresql.org/7/ -- Michael -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
