Postgres Pro
Downloads
Home   >   mailing lists

pgsql: In pg_upgrade, use cached copy of directory listing, rather than - Mailing list pgsql-committers

From Bruce Momjian
Subject pgsql: In pg_upgrade, use cached copy of directory listing, rather than
Date
Msg-id E1P8Mca-0002Tt-IQ@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
In pg_upgrade, use cached copy of directory listing, rather than calling
scandir() with a pattern for every table.

Optimization after report of pg_upgrade slowness with 150k tables.

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=ad06db2610f479d559ee4a3b9e3241d40be07440

Modified Files
--------------
contrib/pg_upgrade/info.c        |   15 +++---
contrib/pg_upgrade/pg_upgrade.h  |   25 ++++------
contrib/pg_upgrade/relfilenode.c |   88 ++++++++++++++++++++++++--------------
3 files changed, 74 insertions(+), 54 deletions(-)

pgsql-committers by date:

Previous
From: Bruce Momjian
Date:
Subject: pgsql: Pgindent run on pg_upgrade source after restructuring.
Next
From: Bruce Momjian
Date:
Subject: pgsql: Cache most recent relfilenode lookups, for speed, after report o