From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: In pg_upgrade, copy fsm, vm, and extent files by checking for fi |
Date: | 2012-11-14 22:32:12 |
Message-ID: | E1TYlVE-0005b7-TW@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
In pg_upgrade, copy fsm, vm, and extent files by checking for file
existence via open(), rather than collecting a directory listing and
looking up matching relfilenode files with sequential scans of the
array. This speeds up pg_upgrade by 2x for a large number of tables,
e.g. 16k.
Per observation by Ants Aasma.
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/29add0de4920e4f448a30bfc35798b939c211d97
Modified Files
--------------
contrib/pg_upgrade/file.c | 55 ----------
contrib/pg_upgrade/pg_upgrade.h | 2 -
contrib/pg_upgrade/relfilenode.c | 208 +++++++++++++++-----------------------
3 files changed, 82 insertions(+), 183 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-11-14 22:39:29 | Re: pgsql: In pg_upgrade, copy fsm, vm, and extent files by checking for fi |
Previous Message | Tom Lane | 2012-11-14 22:30:46 | pgsql: Fix the int8 and int2 cases of (minimum possible integer) % (-1) |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2012-11-14 22:33:29 | Re: Further pg_upgrade analysis for many tables |
Previous Message | Merlin Moncure | 2012-11-14 22:28:09 | Re: WIP checksums patch |