On 18/11/11 04:59, Tom Lane wrote:
Craig Ringer<ringerc@xxxxxxxxxxxxx> writes:
On Nov 17, 2011 1:32 PM, "Tom Lane"<tgl@xxxxxxxxxxxxx> wrote:
If it's purely an insert-only table, such as a logging table, then in
principle you only need periodic ANALYZEs and not any VACUUMs.
Won't a VACUUM FREEZE (or autovac equivalent) be necessary eventually, to
handle xid wraparound?
Sure, but if he's continually adding new rows, I don't see much point in
launching extra freeze operations.
regards, tom lane
Just curious...
Will the pattern of inserts be at all relevant?
For example random inserts compared to apending records. I thought that
random inserts would lead to bloat, as there would be lots of blocks far
from the optimum fill factor.
Regards,
Gavin
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
