[GENERAL] recovering from "too many failures" wal error

All; We have a postgresql 9.2 cluster setup to do continuous wal archiving. We were archiving to a mount point that went offline. As a result the db could not archive the wal files, we ended up with many many errors in the logs indicating the file could not be archived: WARNING: transaction

Re: [GENERAL] When was ANALYZE run in the past?

On Sat, 29 Nov 2014 15:27:07 -0500 Benjamin Rutt wrote: > On *https://wiki.postgresql.org/wiki/Slow_Counting* > I read that > > SELECT reltuples FROM pg_class WHERE relname = 'tbl'; > > may be a good way to get an estimate of the # of rows in

[GENERAL] When was ANALYZE run in the past?

On *https://wiki.postgresql.org/wiki/Slow_Counting* I read that SELECT reltuples FROM pg_class WHERE relname = 'tbl'; may be a good way to get an estimate of the # of rows in the table, but depends on how frequently ANALYZE has been running. I