Re: Performance of INSERT into temporary tables using psqlODBC driver

From: padusuma <venkata(dot)adusumalli(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance of INSERT into temporary tables using psqlODBC driver
Date: 2018-09-16 05:29:24
Message-ID: 1537075764890-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Rory Campbell-Lange 2018-09-16 12:23:36 Advice on machine specs for growth
Previous Message Tim Cross 2018-09-16 02:19:31 Re: Performance of INSERT into temporary tables using psqlODBC driver