** This has not been tested.
Create a ramdisk of required size
Create a Linux software RAID mirror between the ramdisk, and a partition
of the same size.
Mark the physical-disk as write-mostly (reads will go to the ramdisk)
Format it and load data...
On reboot you'll
On Fri, 2006-04-07 at 09:54, Matt Davies | Postgresql List wrote:
> If memory serves me correctly I have seen several posts about this in
> the past.
>
> I'll try to recall highlights.
>
> 1. Create a md in linux sufficiently large enough to handle the data set
> you are wanting to store.
> 2.
On 4/7/06, Charles A. Landemaine <[EMAIL PROTECTED]> wrote:
> I have a web server with PostgreSQL and RHEL. It hosts a search
> engine, and each time some one makes a query, it uses the HDD Raid
> array. The DB is not very big, it is less than a GB. I plan to add
> more RAM anyway.
>
> What I'd lik
"Charles A. Landemaine" <[EMAIL PROTECTED]> writes:
> What I'd like to do is find out how to keep the whole DB in RAM so
> that each time some one does a query, it doesn't use the HDD. Is it
> possible, if so, how?
That should happen essentially for free, if the kernel doesn't have any
better use
If memory serves me correctly I have seen several posts about this in
the past.
I'll try to recall highlights.
1. Create a md in linux sufficiently large enough to handle the data set
you are wanting to store.
2. Create a HD based copy somewhere as your permanent storage mechanism.
3. Start u
On 4/7/06, Matt Davies | Postgresql List <[EMAIL PROTECTED]> wrote:
> Out of curiosity, what are you using as the search engine?
Thank you. We designed the search engine ourself (we didn't use a
ready-to-use solution).
--
Charles A. Landemaine.
---(end of broadcast)--
I have a web server with PostgreSQL and RHEL. It hosts a search
engine, and each time some one makes a query, it uses the HDD Raid
array. The DB is not very big, it is less than a GB. I plan to add
more RAM anyway.
What I'd like to do is find out how to keep the whole DB in RAM so
that each time s
