Re: Performance large tables.

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Performance large tables.
Дата
Msg-id 20051210232649.GA1193@svana.org
обсуждение исходный текст
Ответ на Performance large tables.  (Benjamin Arai <barai@cs.ucr.edu>)
Ответы Re: Performance large tables.  (Benjamin Arai <barai@cs.ucr.edu>)
Список pgsql-general
On Sat, Dec 10, 2005 at 03:22:47PM -0800, Benjamin Arai wrote:
> My issue actually stems from the fact that I cannot do large weekly
> updates on fast enough to meet a weekend window for the following work
> week.  I am currently using a machine with a raid 1, 4GB RAM, and dual
> opteron.  I could go 0+1 but peroformance increase is only about 20%
> from the benchmarks I have read.  ANY suggestions would be greatly
> appreciated.

Since you have given us no information to work with you're not going to
get any specific recommendations either. If you can tell is the things
you do most commonly and are most performance sensetive (exact
commands, timings, versions and settings please) we may be able to
help.
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Benjamin Arai
Дата:
Сообщение: Performance large tables.
Следующее
От: Benjamin Arai
Дата:
Сообщение: Re: Performance large tables.