Re: Performace Optimization for Dummies

Поиск
Список
Период
Сортировка
От Markus Schaber
Тема Re: Performace Optimization for Dummies
Дата
Msg-id 45221D5D.2020003@logix-tt.com
обсуждение исходный текст
Ответ на Re: Performace Optimization for Dummies  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
Список pgsql-performance
Hi, Carlo,

Carlo Stonebanks wrote:

>> Trying to achieve a high level of data quality in one large project is
>> not often possible. Focus on the most critical areas of checking and get
>> that working first with acceptable performance, then layer on additional
>> checks while tuning. The complexity of the load programs you have also
>> means they are susceptible to introducing data quality problems rather
>> than removing them, so an incremental approach will also aid debugging
>> of the load suite.
>
> I couldn't agree more.

I still think that using a PL in the backend might be more performant
than having an external client, alone being the SPI interface more
efficient compared to the network serialization for external applications.

HTH,
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org

В списке pgsql-performance по дате отправления:

Предыдущее
От: Markus Schaber
Дата:
Сообщение: Re: Performace Optimization for Dummies
Следующее
От: "Carlo Stonebanks"
Дата:
Сообщение: Performance Optimization for Dummies 2 - the SQL