pgsql: Modify pgstats code to reduce performance penalties from

Поиск
Список
Период
Сортировка
От tgl@postgresql.org (Tom Lane)
Тема pgsql: Modify pgstats code to reduce performance penalties from
Дата
Msg-id 20060118203506.8E5EB9DC87B@postgresql.org
обсуждение исходный текст
Список pgsql-committers
Log Message:
-----------
Modify pgstats code to reduce performance penalties from oversized stats data
files: avoid creating stats hashtable entries for tables that aren't being
touched except by vacuum/analyze, ensure that entries for dropped tables are
removed promptly, and tweak the data layout to avoid storing useless struct
padding.  Also improve the performance of pgstat_vacuum_tabstat(), and make
sure that autovacuum invokes it exactly once per autovac cycle rather than
multiple times or not at all.  This should cure recent complaints about 8.1
showing much higher stats I/O volume than was seen in 8.0.  It'd still be a
good idea to revisit the design with an eye to not re-writing the entire
stats dataset every half second ... but that would be too much to backpatch,
I fear.

Modified Files:
--------------
    pgsql/src/backend/commands:
        vacuum.c (r1.320 -> r1.321)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/vacuum.c.diff?r1=1.320&r2=1.321)
    pgsql/src/backend/postmaster:
        autovacuum.c (r1.9 -> r1.10)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/autovacuum.c.diff?r1=1.9&r2=1.10)
        pgstat.c (r1.119 -> r1.120)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/pgstat.c.diff?r1=1.119&r2=1.120)
    pgsql/src/backend/storage/smgr:
        smgr.c (r1.94 -> r1.95)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/smgr/smgr.c.diff?r1=1.94&r2=1.95)
    pgsql/src/include:
        pgstat.h (r1.40 -> r1.41)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/pgstat.h.diff?r1=1.40&r2=1.41)

В списке pgsql-committers по дате отправления:

Предыдущее
От: momjian@postgresql.org (Bruce Momjian)
Дата:
Сообщение: pgsql: Done: > o -Allow pooled connections to list all open WITH HOLD
Следующее
От: tgl@postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Modify pgstats code to reduce performance penalties from