nunks <nunks.lol@xxxxxxxxx> writes: > I deal with some big (TB-level) partitioned tables where the application > does a hybrid of querying both the master and the child tables directly. > This clarification will be very useful. BTW, the autovacuum daemon is normally fairly good about analyzing tables when the individual-table stats need updating (or if you think it isn't, you can adjust its parameters to make it more or less aggressive about that). Where it falls down is actually in maintenance of whole-tree stats: it does not realize that a bunch of updates on a child table should prompt auto-analyze of the parent table as well as the child. So I'd actually not think that you need to worry too much about manual ANALYZEs of the children. You might indeed need to help things out with periodic manual ANALYZEs of the parent table, though. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
