Can postgresql be run in memory (like a memory resident program)
Is it possible to run post-gresql in memory? I searched through all the
older postings didn't find much info.
Thanks
Ravi
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:
Show quoted text
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)
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:
Show quoted text
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.eduOn 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?
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"