Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group