Re: Question on hardware & server capacity

Поиск
Список
Период
Сортировка
От Steve Wolfe
Тема Re: Question on hardware & server capacity
Дата
Msg-id 006601c2b369$a2427ec0$88693fd1@WEASEL
обсуждение исходный текст
Ответ на Re: Question on hardware & server capacity  ("scott.marlowe" <scott.marlowe@ihs.com>)
Ответы Re: Question on hardware & server capacity  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
> Actually, free memory doesn't mean a whole lot.  How much memory is
being
> used as cache by the kernel?

  Generally, a gig or so.

> Can you distribute your dataset across multiple machines?  or is it the
> kinda thing that all needs to be in one big machine?

  We're splitting the front-end across a number of machines, but all of
the various datasets are sufficiently intertwined that they all have to be
in the same database.  I'm going to fiddle around with some of the
available replication options and see if they're robust enough to put them
into production.

steve


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

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: Question on hardware & server capacity
Следующее
От: Hilmar Lapp
Дата:
Сообщение: Re: join over 12 tables takes 3 secs to plan