| From: | Markus Schaber <schabi(at)logix-tt(dot)com> |
|---|---|
| To: | Carlo Stonebanks <stonec(dot)register(at)sympatico(dot)ca> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Performace Optimization for Dummies |
| Date: | 2006-10-03 08:20:45 |
| Message-ID: | 45221D5D.2020003@logix-tt.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carlo Stonebanks | 2006-10-03 08:33:01 | Performance Optimization for Dummies 2 - the SQL |
| Previous Message | Markus Schaber | 2006-10-03 08:15:27 | Re: Performace Optimization for Dummies |