AW: AW: Call for alpha testing: planner statistics revi sion s

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: AW: AW: Call for alpha testing: planner statistics revi sion s
Date: 2001-06-18 15:21:09
Message-ID: 11C1E6749A55D411A9670001FA68796336832F@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> > Because we do not want the dba to decide which statistics are optimal,
> > there should probably be an analyze helper application that is invoked
> > with "vacuum analyze database optimal" or some such, that also decides
> > whether a table was sufficiently altered to justify new stats gathering
> > or vacuum.
>
> And on what are you going to base "sufficiently altered"?

Probably current table size vs table size in statistics and maybe timestamp
when statistics were last updated. Good would also be the active row count, but
we don't have cheap access to the current value.

The point is, that if the combined effort of all "hackers" (with the help of
some large scale users) cannot come to a more or less generally adequate answer,
the field dba most certainly won't eighter.

Andreas

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-06-18 15:31:19 Re: AW: AW: Call for alpha testing: planner statistics revi sion s
Previous Message Tom Lane 2001-06-18 15:00:16 Re: initdb from current cvs failed