> [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.
