On Sat, Jun 11, 2011 at 4:37 PM, Reuven M. Lerner wrote:
> Hi, Greg. Thanks for the quick and useful answer, even if it means that my
> hopes for a quick fix have been dashed. I guess I'll need to do some actual
> monitoring, then...
You mention pg_stat_user_tables, what did the last_analyze co
Hi, Greg. Thanks for the quick and useful answer, even if it means that
my hopes for a quick fix have been dashed. I guess I'll need to do some
actual monitoring, then...
Reuven
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscriptio
Reuven M. Lerner wrote:
Could this be because we're only doing INSERTs and SELECTs? In such a
case, then we would never reach the threshold of modified tuples that
autovacuum looks for, and thus it would never run. That would, by my
reasoning, mean that we'll never tag dead tuples (which isn'
