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

From Carlo Stonebanks
Subject Re: Performace Optimization for Dummies
Date
Msg-id efi7gk$24u9$1@news.hub.org
Whole thread Raw
In response to Performace Optimization for Dummies  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
List pgsql-performance
> Something else to consider... databases love doing bulk operations. It
> might be useful to load prospective data into a temporary table, and
> then do as many operations as you can locally (ie: within the database)
> on that table, hopefully eleminating as many candidate rows as possible
> along the way.

I wish this would work... it was definitely something I considered early on
in the project. Even thinking of explaining why it won't work is giving me a
headache...

But I sure wish it would.



pgsql-performance by date:

Previous
From: Matthew Nuzum
Date:
Subject: Re: Performace Optimization for Dummies
Next
From: "Carlo Stonebanks"
Date:
Subject: Re: Performace Optimization for Dummies