Re: Performance of INSERT into temporary tables using psqlODBC driver

2018-09-15 Thread Tim Cross
padusuma writes: > Hello Tim, > >>How are you gathering metrics to determine if performance has improved >>or not? > I am measuring the response times through timer for the execution of SQL > statements through psqlODBC driver. The response times for INSERT INTO > temp-table statements have

Re: Performance of INSERT into temporary tables using psqlODBC driver

2018-09-15 Thread padusuma
Hello Tim, >How are you gathering metrics to determine if performance has improved >or not? I am measuring the response times through timer for the execution of SQL statements through psqlODBC driver. The response times for INSERT INTO temp-table statements have not changed with the parameters

Re: How Do You Associate a Query With its Invoking Procedure?

2018-09-15 Thread Patrick Molgaard
You might find application-level tracing a more practical answer - e.g. check out Datadog APM for a (commercial) plug and play approach or Jaeger for a self-hostable option. Patrick On Fri, Sep 14, 2018 at 4:38 PM Fred Habash wrote: > Any ideas, please? > > On Thu, Sep 13, 2018, 3:49 PM Fd