Re: Vacuuming - Mailing list pgsql-general

From Paul Lambert
Subject Re: Vacuuming
Date
Msg-id 463FFFC5.1060909@autoledgers.com.au
Whole thread Raw
In response to Re: Vacuuming  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
>
> I forgot to mention that any other operation that examines every table
> row will fix all the hint bits as well.  In particular a CREATE INDEX
> would do that --- so if you are planning to create some indexes then
> there's certainly no point in a VACUUM just after a table load.
>
>             regards, tom lane
>

Thanks for all the help Tom, educational as always.

--
Paul Lambert
Database Administrator
AutoLedgers

pgsql-general by date:

Previous
From: "Harvey, Allan AC"
Date:
Subject: 'Expensive' column in result set
Next
From: Oleg Bartunov
Date:
Subject: Re: tokenize string for tsearch?