Re: Performace Optimization for Dummies - Mailing list pgsql-performance

From Markus Schaber
Subject Re: Performace Optimization for Dummies
Date
Msg-id 45221D5D.2020003@logix-tt.com
Whole thread Raw
In response to Re: Performace Optimization for Dummies  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
List 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 by date:

Previous
From: Markus Schaber
Date:
Subject: Re: Performace Optimization for Dummies
Next
From: "Carlo Stonebanks"
Date:
Subject: Performance Optimization for Dummies 2 - the SQL