Date: Sat, 15 Sep 2018 22:29:24 -0700 (MST)
From: padusuma <venkata.adusumalli@gmail.com>
To: pgsql-performance@postgresql.org
Message-ID: <1537075764890-0.post@n3.nabble.com>
In-Reply-To: <87k1nmgp58.fsf@gmail.com>
References: <1536339842382-0.post@n3.nabble.com> <8736uk6eh5.fsf@gmail.com>
 <1536385261054-0.post@n3.nabble.com> <87zhwq48ap.fsf@gmail.com>
 <1536554876104-0.post@n3.nabble.com> <1536843459130-0.post@n3.nabble.com>
 <87tvmtvx4h.fsf@gmail.com> <1537030803688-0.post@n3.nabble.com>
 <87k1nmgp58.fsf@gmail.com>
Subject: Re: Performance of INSERT into temporary tables using psqlODBC
 driver
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk

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 
>problem domain. Design is often cleaner and as a result, easier to 
>maintain. It usually takes a lot less time than the original 
>implementation as well and can be the more economical solution compared 
>to fighting a system which has fundamental design limitations that 
>restrict performance.

Thank you for the suggestions and advice. I will definitely look into
re-implementation of certain parts of our solution as an option to improve
performance.


--
Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html