Hi all,
To satisfy my own curiosity, I was trying to find where 8.4 kicks into a
backwards scan of the data file during (auto-)vacuuming.
This appears to be repair_frag() in backend/commands/vacuum.c, but only appears
to be called by a FULL vacuum. Autovacuum, however, appears to explicitly on
List,
Can anyone suggest where the below error comes from, given I'm attempting to
load HTTP access log data with reasonably small row and column value lengths?
logs=# COPY raw FROM '/path/to/big/log/file' DELIMITER E'\t' CSV;
ERROR: out of memory
DETAIL: Cannot enlarge