|
|
|
|
|
|
by nierman
3980 days ago
|
|
|
Running more aggressive vacuums that will clean up "old" tuples/tables is good for off-peak times. See Josh Berkus' short three part blog series on postgres' vacuum/freeze:
http://www.databasesoup.com/2012/09/freezing-your-tuples-off... and his python script for doing this:
https://github.com/pgexperts/flexible-freeze Also, note that long running transactions can prevent cleanup of tuples. Look for old xact_start values of non-idle queries in pg_stat_activity (particularly "idle in transaction" connections) and old entries in pg_prepared_xacts. |
|
|