Hi,
Has anyone tried generating a dynamic memory trace of a backend Postgres
process while it's running a query?
I want to characterize the memory access pattern of the Postgres database
engine when it's running any given query. The usual way to do this would be
to attach a dynamic instrumentation tool like DynamoRIO or Intel Pin to the
backend process running the query (?). How could I find the exact backend
process to attach to? Also, if there's any prior experience with generating
such memory traces, it would be helpful to know what tools were used.
best regards,
Muneeb Khan