Re: PostgreSQL clustering VS MySQL clustering

Поиск
Список
Период
Сортировка
От Olivier Sirven
Тема Re: PostgreSQL clustering VS MySQL clustering
Дата
Msg-id 200501311616.07955.osirven@elma.fr
обсуждение исходный текст
Ответ на Re: PostgreSQL clustering VS MySQL clustering  (Marty Scholes <marty@outputservices.com>)
Список pgsql-performance
Le Vendredi 21 Janvier 2005 19:18, Marty Scholes a écrit :
> The indexes can be put on a RAM disk tablespace and that's the end of
> index problems -- just make sure you have enough memory available.  Also
> make sure that the machine can restart correctly after a crash: the
> tablespace is dropped and recreated, along with the indexes.  This will
> cause a machine restart to take some time.
Tell me if I am wrong but it sounds to me like like an endless problem....This
solution may work with small indexes (less than 4GB) but what appends when
the indexes grow ? You would add more memory to your server ? But there will
be a moment were you can not add more so what's next ?

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

Предыдущее
От: "Peter Darley"
Дата:
Сообщение: Re: Possibly slow query
Следующее
От: Marty Scholes
Дата:
Сообщение: Re: PostgreSQL clustering VS MySQL clustering