Re: Performace Optimization for Dummies
- From: "Carlo Stonebanks" <stonec(dot)register(at)sympatico(dot)ca>
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Performace Optimization for Dummies
- Date: Fri, 29 Sep 2006 00:30:23 -0400
- Message-id: <efi7gk$24u9$1(at)news(dot)hub(dot)org>
> 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.
Home |
Main Index |
Thread Index