Re: pg_freespacemap question
От
Alvaro Herrera
Тема
Re: pg_freespacemap question
Дата
Msg-id
20060307234924.GA9838@surnet.cl
Ответ на
Re: pg_freespacemap question (Tatsuo Ishii)
Список
Дерево обсуждения
pg_freespacemap question Tatsuo Ishii <ishii@sraoss.co.jp>
Re: pg_freespacemap question Peter Eisentraut <peter_e@gmx.net>
Re: pg_freespacemap question Alvaro Herrera <alvherre@commandprompt.com>
Re: pg_freespacemap question Tatsuo Ishii <ishii@sraoss.co.jp>
Re: pg_freespacemap question Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_freespacemap question Mark Kirkwood <markir@paradise.net.nz>
Re: pg_freespacemap question Mark Kirkwood <markir@paradise.net.nz>
Re: pg_freespacemap question Tatsuo Ishii <ishii@sraoss.co.jp>
Re: pg_freespacemap question Alvaro Herrera <alvherre@commandprompt.com>
Re: pg_freespacemap question Mark Kirkwood <markir@paradise.net.nz>
Re: pg_freespacemap question Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_freespacemap question Mark Kirkwood <markir@paradise.net.nz>
Re: pg_freespacemap question Tatsuo Ishii <ishii@sraoss.co.jp>
Re: [PATCHES] pg_freespacemap question Tatsuo Ishii <ishii@sraoss.co.jp>
Re: [PATCHES] pg_freespacemap question Mark Kirkwood <markir@paradise.net.nz>
Re: [PATCHES] pg_freespacemap question Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCHES] pg_freespacemap question Tatsuo Ishii <ishii@sraoss.co.jp>
Re: [PATCHES] pg_freespacemap question Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCHES] pg_freespacemap question Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: [PATCHES] pg_freespacemap question Mark Kirkwood <markir@paradise.net.nz>
Re: [PATCHES] pg_freespacemap question Alvaro Herrera <alvherre@commandprompt.com>
Re: [PATCHES] pg_freespacemap question Mark Kirkwood <markir@paradise.net.nz>
Re: [PATCHES] pg_freespacemap question Mark Kirkwood <markir@paradise.net.nz>
Re: [PATCHES] pg_freespacemap question Bruce Momjian <pgman@candle.pha.pa.us>
Re: pg_freespacemap question Bruce Momjian <pgman@candle.pha.pa.us>
Tatsuo Ishii wrote: > Just for curiousity, why FSM gathers info for indexes? I thought FSM > is only good for tables. It's part of the implementation of the page-recycling algorithm for btrees Tom did for 7.4. When a btree page is empty after a vacuum, it's entered in the free space map. When a page is split, the new page is taken from the FSM (or the relation is extended if there isn't any.) That's why the bytes-free number is zero: when a btree page makes it into the FSM, we are sure it's completely empty. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
В списке pgsql-hackers по дате отправления
