Re: PostgreSQL clustering VS MySQL clustering

From: Olivier Sirven <osirven(at)elma(dot)fr>
To: Marty Scholes <marty(at)outputservices(dot)com>
Cc: herve(at)elma(dot)fr, pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL clustering VS MySQL clustering
Date: 2005-01-31 15:16:07
Message-ID: 200501311616.07955.osirven@elma.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Marty Scholes 2005-01-31 15:24:55 Re: PostgreSQL clustering VS MySQL clustering
Previous Message Peter Darley 2005-01-31 15:06:50 Re: Possibly slow query