Re: Automatic free space map filling - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Automatic free space map filling
Date
Msg-id 17985.1146680074@sss.pgh.pa.us
Whole thread Raw
In response to Re: Automatic free space map filling  (Hannu Krosing <hannu@skype.net>)
List pgsql-hackers
Hannu Krosing <hannu@skype.net> writes:
> If you mean the full cycle, then it is probably not worth it, as even a
> single 'clean index' pass can take hours on larger tables.

The patch Heikki is working on will probably alleviate that problem,
because it will allow vacuum to scan the indexes in physical rather than
logical order.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: sblock state on FreeBSD 6.1
Next
From: "Larry Rosenman"
Date:
Subject: Re: sblock state on FreeBSD 6.1