Hi all,
Quick question: is there currently a way to see how many slot are
used in the FSM (i.e. how many free pages are stored there), or how
many are free? If not, wouldn't it be a good idea to add this
somewhere? (Don't quite know where... is it possible to have very
dynamic values in show
Hi Tom,
At 02:51 10/11/2007, Tom Lane wrote:
Uh, no, it's called only when we've advanced datfrozenxid,
which is a pretty uncommon event. So I think the real hole in the
proposal is that there would be a long and not-very-predictable delay
between changing the parameter and having it really
Hi,
I was wondering why autovacuum_freeze_max_age actually can't be set
at runtime... guc.c points to varsup.c which says:
* Note: autovacuum_freeze_max_age is a PGC_POSTMASTER
parameter so that
* we don't have to worry about dealing with on-the-fly changes in its
Hi,
It is well known that in some instances the Postgresql will make
estimates of the number of distinct values in a table that can be
quite far off reality. This then has a tendency to make the planner
lean towards unsavory plans (read: seqscans) because it estimates the
number of lines
