Thread: 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: > 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: >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 > >
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"