From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Split pgstat file in smaller pieces |
Date: | 2013-02-18 21:16:55 |
Message-ID: | E1U7Y51-0005VD-Ox@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Split pgstat file in smaller pieces
We now write one file per database and one global file, instead of
having the whole thing in a single huge file. This reduces the I/O that
must be done when partial data is required -- which is all the time,
because each process only needs information on its own database anyway.
Also, the autovacuum launcher does not need data about tables and
functions in each database; having the global stats for all DBs is
enough.
Catalog version bumped because we have a new subdir under PGDATA.
Author: Tomas Vondra. Some rework by Álvaro
Testing by Jeff Janes
Other discussion by Heikki Linnakangas, Tom Lane.
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/187492b6c2e8cafc5b39063ca3b67846e8155d24
Modified Files
--------------
src/backend/postmaster/pgstat.c | 807 +++++++++++++++++++++++++++-----------
src/backend/utils/misc/guc.c | 17 +-
src/bin/initdb/initdb.c | 1 +
src/include/catalog/catversion.h | 2 +-
src/include/pgstat.h | 5 +-
5 files changed, 593 insertions(+), 239 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2013-02-18 21:48:05 | Re: Materialized views WIP patch |
Previous Message | Noah Misch | 2013-02-18 20:28:43 | Re: Materialized views WIP patch |