Re: Performace Optimization for Dummies

Поиск
Список
Период
Сортировка
От Carlo Stonebanks
Тема Re: Performace Optimization for Dummies
Дата
Msg-id efi7gk$24u9$1@news.hub.org
обсуждение исходный текст
Ответ на Performace Optimization for Dummies  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
Список 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 по дате отправления:

Предыдущее
От: Matthew Nuzum
Дата:
Сообщение: Re: Performace Optimization for Dummies
Следующее
От: "Carlo Stonebanks"
Дата:
Сообщение: Re: Performace Optimization for Dummies