Thread: Can postgresql be run in memory (like a memory resident program)

Can postgresql be run in memory (like a memory resident program)

From
"Malghan, Ravi"
Date:
Is it possible to run post-gresql in memory? I searched through all the
older postings didn't find much info.

Thanks
Ravi

Re: Can postgresql be run in memory (like a memory resident

From
Andrew Perrin
Date:
What is it that you want to *do*?  Like any program, while postgresql is
running, parts of it are in memory.

ap

----------------------------------------------------------------------
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
clists@perrin.socsci.unc.edu * andrew_perrin (at) unc.edu


On Tue, 25 Feb 2003, Malghan, Ravi wrote:

> Is it possible to run post-gresql in memory? I searched through all the
> older postings didn't find much info.
>
> Thanks
> Ravi
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>


Re: Can postgresql be run in memory (like a memory resident

From
Medi Montaseri
Date:
You could create a RAM disk but one of the important directive a DB
engine design is
persistency.....since RAM is non-persistent, then you'll lose the
content everytime you
reboot.....is that OK ?

Andrew Perrin wrote:

>What is it that you want to *do*?  Like any program, while postgresql is
>running, parts of it are in memory.
>
>ap
>
>----------------------------------------------------------------------
>Andrew J Perrin - http://www.unc.edu/~aperrin
>Assistant Professor of Sociology, U of North Carolina, Chapel Hill
>clists@perrin.socsci.unc.edu * andrew_perrin (at) unc.edu
>
>
>On Tue, 25 Feb 2003, Malghan, Ravi wrote:
>
>
>
>>Is it possible to run post-gresql in memory? I searched through all the
>>older postings didn't find much info.
>>
>>Thanks
>>Ravi
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 2: you can get off all lists at once with the unregister command
>>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>>
>>
>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
>
>




Re: Can postgresql be run in memory (like a memory resident program)

From
Christopher Browne
Date:
Martha Stewart called it a Good Thing whenrmalghan@btspartners.com ("Malghan, Ravi")wrote:
> Is it possible to run post-gresql in memory? I searched through all the
> older postings didn't find much info.

You could presumably mount the databases on an in-memory filesystem
such as the oft-available "tempfs", and thus have the data reside "in
memory."

But more realistically if this is what you /truly/ want, you should
probably look at other packages like FastDB or Speedy.
--
output = ("aa454" "@freenet.carleton.ca")
http://cbbrowne.com/info/rdbms.html
"You can not reason a man out  of a position he  did not reach through
reason"