Re: Giant TOAST tables due to many almost empty pages

Tom Lane wrote:
<snip>
>
> There's something extremely wacko about that vacuum output. A toast
> table should have few, if any, rows that short. And it's impossible
> to believe there's no free space at all in the table, especially since
> 122*3259181 bytes is still quite a lot less than 3259181 pages. Are
> you running with any nonstandard storage or vacuum parameters?
>
> regards, tom lane
>

Regarding storage paramaters, you mean ALTER TABLE x SET STORAGE...? Then no.

Only autovacuum settings are changed to be a bit more aggressive, vacuum
settings haven't been touched:
# select name,setting from pg_settings where source not in
('default','override') AND name LIKE '%vacuum%';
name | setting
--------------------------------+---------
autovacuum_max_workers | 4
autovacuum_naptime | 45
autovacuum_vacuum_cost_delay | 15
autovacuum_vacuum_cost_limit | 2000
autovacuum_vacuum_scale_factor | 0.1
autovacuum_vacuum_threshold | 75
(6 rows)