Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Performace Optimization for Dummies
- From: Markus Schaber <schabi(at)logix-tt(dot)com>
- To: pgsql-performance(at)postgresql(dot)org
- Cc: stonec(dot)register(at)sympatico(dot)ca
- Subject: Re: Performace Optimization for Dummies
- Date: Fri, 29 Sep 2006 14:19:51 +0200
- Message-id: <451D0F67(dot)4040309(at)logix-tt(dot)com>
Hi, Carlo, Carlo Stonebanks wrote: > We urgently need a major performance improvement. Did you think about putting the whole data into PostgreSQL using COPY in a nearly unprocessed manner, index it properly, and then use SQL and stored functions to transform the data inside the database to the desired result? We're using this way for some 3rd-party databases we have to process in-house. 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
- References:
- Performace Optimization for Dummies
- From: Carlo Stonebanks
- Performace Optimization for Dummies
- Prev by Date: Re: any hope for my big query?
- Next by Date: Re: Performace Optimization for Dummies
- Previous by thread: Re: Performace Optimization for Dummies
- Next by thread: [no subject]
- Indexes: