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

2018-09-16 Thread Fred Habash
All great ideas. I was thinking something similar to some other RDBMS engines where SQL is automatically tied to the invoking PROGRAM_ID with zero setup on the client side. I thought there could be something similar in PG somewhere in the catalog. As always, great support. This level of supp

Advice on machine specs for growth

2018-09-16 Thread Rory Campbell-Lange
It is some time since I've written to the postgres lists. My apologies if this is the wrong list to post this to. We are looking to upgrade our current database server infrastructure so that it is suitable for the next 3 years or so. Presently we have two physical servers with the same specs:

Re: Performance of INSERT into temporary tables using psqlODBC driver

2018-09-16 Thread padusuma
Hello Tim, >Re-implementation of a solution is often a hard case to sell, but it >might be the only way to get the performance you want. The big positive >to a re-implementation is that you usually get a better solution because >you are implementing with more knowledge and experience about the