> [snip] Having an expensive process run once in a while and setting this value
> also
> sounds interesting. [snip]
What about externalizing the statistics calculation ? I mean, would it
make sense to have for e.g. a WAL-fed standby which has an additional
process which keeps the statistics in sync based on the incoming WAL
records, and feeds back the stats to the master as soon as they change
significantly ? The standby would be able to crunch ALL the data, in
almost real time... with almost no overhead for the master. It would
require though another server... but I guess where analyze is a problem,
throwing another server at it is not a problem.
Cheers,
Csaba.
---------------------------(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
