Andres Freund <andres@xxxxxxxxxxx> writes: > On 2017-05-05 14:24:07 -0600, Mathieu Fenniak wrote: >> It appears that most of the time is spent in the >> RelfilenodeMapInvalidateCallback and CatalogCacheIdInvalidate cache >> invalidation callbacks, both of which appear to be invalidating caches >> based upon the cache value. > I think optimizing those has some value (and I see Tom is looking at > that aspect, but the bigger thing would probably be to do fewer lookups. I'm confused --- the lookup side of things is down in the noise in Mathieu's trace. Further reducing the number of lookups doesn't seem like it helps this scenario at all. It might matter once we've whacked down the cost of invalidations ... regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
