Is there a way to run tables in RAM?

Поиск
Список
Период
Сортировка
От Roy Souther
Тема Is there a way to run tables in RAM?
Дата
Msg-id 1152812683.17882.341.camel@DesktopServer
обсуждение исходный текст
Ответы Re: Is there a way to run tables in RAM?  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Is there a way to run tables in RAM?  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Is there a way to run tables in RAM?  ("Merlin Moncure" <mmoncure@gmail.com>)
Re: Is there a way to run tables in RAM?  ("Tim Hart" <tjhart@mac.com>)
Re: Is there a way to run tables in RAM?  ("Karen Hill" <karen_hill22@yahoo.com>)
Re: Is there a way to run tables in RAM?  (Ron Johnson <ron.l.johnson@cox.net>)
Список pgsql-general
I would like to know if there is anyway to move a section of some tables into RAM to work on them.

I have large table, about 700MB or so and growing. I also have a bizarre collection of queries that run hundreds of queries on a small section of this table. These queries only look at about 100 or so records at a time and they run hundreds of queries on the data looking for patterns. This causes the program to run very slowly because of hard drive access time. Some times it needs to write changes back to the records it is working with.

Is there anyway that I can move a few hundred records of the table into RAM and work on it there, it would be much faster.

Is there anyway to create a temporary table that will only exist in RAM and not be written to the hard drive? Or do temporary tables already do that?

If I can use a temporary table this way is there any simple way to merge the changes back into the original table?

Royce Souther
www.SiliconTao.com
Let Open Source help your business move beyond.

For security this message is digitally authenticated by GnuPG.



Вложения

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

Предыдущее
От: "Shoaib Mir"
Дата:
Сообщение: Re: Database connectivity using ECPG
Следующее
От: Joe Conway
Дата:
Сообщение: Re: Trying to connect to an Oracle instance...