Re: [COMMITTERS] pgsql: Clean up code associated with updating pg_class statistics

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: [COMMITTERS] pgsql: Clean up code associated with updating pg_class statistics
Дата
Msg-id 20060511041543.GA2661@surnet.cl
обсуждение исходный текст
Ответы Re: [COMMITTERS] pgsql: Clean up code associated with updating pg_class statistics
Список pgsql-hackers
Tom Lane wrote:
> Log Message:
> -----------
> Clean up code associated with updating pg_class statistics columns
> (relpages/reltuples).  To do this, create formal support in heapam.c for
> "overwrite" tuple updates (including xlog replay capability) and use that
> instead of the ad-hoc overwrites we'd been using in VACUUM and CREATE INDEX.
> Take the responsibility for updating stats during CREATE INDEX out of the
> individual index AMs, and do it where it belongs, in catalog/index.c.  Aside
> from being more modular, this avoids having to update the same tuple twice in
> some paths through CREATE INDEX.  It's probably not measurably faster, but
> for sure it's a lot cleaner than before.

Minor comment: since you removed the ----- lines from the index_create
header comment, I think pgindent will mess up the alignment for that
comment, which probably will not be very nice.  Same in
index_update_stats.  Otherwise, nice work!  I will update my relminxid
patch to this and re-submit.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


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

Предыдущее
От: "Jaime Casanova"
Дата:
Сообщение: Re: BEGIN inside transaction should be an error
Следующее
От: Dennis Bjorklund
Дата:
Сообщение: Re: BEGIN inside transaction should be an error