> >             unpatched       HOT     
> > autovacuums 116             43
> > autoanalyzes        139             60
> > HOT greatly reduces the number of vacuums needed. That's 
> good, that's 
> > where the gains in throughput in longer I/O bound runs comes from.
> But surely failing to auto-analyze after a HOT update is a bad thing.

Well, the definition is that no index columns changed, so this seems
It seems for OLTP you should not need an analyze, but for DSS filtering
or joining
on non indexed columns you would. And that would also only be relevant
if you created
custom statistics on non indexed columns.


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to